Translate to Tamil

Earn Money


Best Offers

Amazon Best Offers

Offers

Online Income

Best Online Offers

Amazon Offers

Wednesday, 5 January 2011

What are the advantages of using Stored Procedures?


Stored procedure can reduced network traffic and latency, boosting application performance.

2.     Stored procedure execution plans can be reused, staying cached in SQL Server's memory, reducing server overhead.

3.     Stored procedures help promote code reuse.

4.     Stored procedures can encapsulate logic. You can change stored procedure code without affecting clients.

5.     Stored procedures provide better security to your data.


 Share This Post


No comments:
Write comments

Infolinks

Services

© 2014