There are many advantages of Stored Procedures.
I have to pick only ONE. It is tough question.
I answered : 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)
Not to mentioned I received the second question following my answer : Why? Because all the other advantage known (they are mentioned below) of SP can be achieved without using SP. Though Execution Plan Retention and Reuse can only be achieved using Stored Procedure only.
Reference : Pinal Dave (http://www.SQLAuthority.com)
Ağu 16
This entry was posted on Cumartesi, Ağustos 16th, 2008 at 08:53and is filed under MsSQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
Leave a Reply
You must be logged in to post a comment.