What are the advantages of using Stored procedure

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

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

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

Bookmark It

< Previous : Differences between Show and ShowDialog methods?

Next > : What is PInvoke?

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

More Interview Questions by Karthikanbarasan

Latest Interview Questions