1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........
2 10613you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required
3 49051.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks
5 238811.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?
3 9208Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?
3 5531
How to execute multiple stored procedures at one time in sql server?
What is trigger and different types of Triggers?
Explain about builtinadministrator?
How to delete existing rows in a table?
What are the character string functions supported by sql server 2005?
How to retrieve error messages using odbc_errormsg()?
List few advantages of stored procedure.
how would you store your query in an SSRS report or a Database server?
What are transactions in sql?
How to connect sql server management studio express to sql server 2005 express?
Give main differences between "Truncate" and "Delete".
How to drop existing views from a database in ms sql server?
What is the difference between for xml raw and for xml auto?
How do I install sql server?
What is the dbcc command and why is it used?