Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71732 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
What do you know about system database? : SQL Server Architecture
what stored procedure would you use to view lock information? : Sql server administration
How do you open a cluster administrator?
How to test values returned by a subquery with the in operator?
What is the contrast between sql and pl/sql?
what are the new features in SSRS?
What is the difference between online clustering and Offline clustering?
What is a covered index?
What you can do to delete a table without the delete trigger firing?
How to create a trigger for insert only?
What are the results of running this script?
What are partitioned views?
What is format parameter in ssrs?
How to find Duplicate Records In table?
What are the purposes and advantages stored procedure?
