What are the advantages of using Stored Procedures?

What are the advantages of using Stored Procedures?

There are many different advantages of using Stored Procedures which is following here : 
> Its help promote code reuse.
> It can encapsulate logic. We can change stored procedure code without affecting clients.
> It provide better security to our data.
> It can be reduced network traffic and latency, boosting application performance.
> Stored procedure execution plans can be reused, staying cached in SQL Server\'s memory, reducing server overhead.

By:UMANG
Date:2012-01-09 00:00:00

Post Your Answers


User Email:

User Name:
Answers:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher