What are the advantages of using Stored procedure

 Posted by Karthikanbarasan on 1/31/2011 | Category: Sql Server Interview questions | Views: 7006 | Points: 40
Answer:

Stored procedure provides high security - All Grand and Revoke access can be given to the base table using stored procedures
Stored procedures avoid network traffic - Sql server prepares a cache of the sp and it avoid network traffic
Stored procedure provide performance - Every execution of sp will be take care by query analyser to prepare a layout before executing


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Questpond on: 1/31/2011 | Points: 10
Stored procedures are precompiled and so have high performance. This is one os the biggest benefit of stored procedures.

You can update the sequence with the last one first.
Posted by: Questpond on: 1/31/2011 | Points: 10
Stored procedures are precompiled and so have high performance. This is one os the biggest benefit of stored procedures.

You can update the sequence with the last one first.

Regards,
Important SQL Server interview questions
http://www.questpond.com/dotnet/SQL-Server-Interview-Questions-and-Answers-on-intergration-part3.html

Login to post response