Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71893 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / tmp
the main advantages is Execution Plan Retention and Reuse (SP are compiled and their execution plan is cached and used again to when the same SP is executed again)
http://blog.sqlauthority.com/2007/04/13/sql-server-stored-procedures-advantages-and-best-advantage/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define self join?
What is surrogate key? : sql server analysis services, ssas
What is an execution plan? How would you view the execution plan?
how many layers of tcp/ip protocol combined of? : Sql server database administration
Define the one-to-one relationship while designing tables.
Explain a differential backup?
What are the properties of the transaction?
How can I create a new template for import ? : sql server management studio
How to convert a unicode strings to non-unicode strings?
What is implicit mode in sql server?
 Explain what is sql override for a source taLle in a mapping?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What is cube dimension? : sql server analysis services, ssas
What is difference between createstatement and preparedstatement?
