Amazon Best Offer

AliExpress Offers

Online Income

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

Friendly Learn Translate to Tamil



© 2014