Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / santhanakumari
SP r nothing but collection of SQL stments and control flow
of language.it execute very fastly than a stand alone sql
statment because its a precompiled statement.SPs r reduce
the network traffic
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is explicit mode in sql server?
What is the main difference between ‘between’ and ‘in’ condition operators?
How do I find the sql server version?
What is the use of builtinadministrators group in sql server? : sql server security
please differentiate between delete and truncate?
What are the essential components of sql server service broker?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
what are user defined datatypes? : Sql server database administration
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
How to run sql server 2005 books online on your local system?
Define Unique Key?
How to create a user name in a database?
What is service broker?
How can you stop stored procedures from recompiling?
How can we rewrite sub-queries into simple select statements or with joins?
