RSS‎ > ‎

SQL :: List few advantages of Stored Procedure.

posted Sep 21, 2012, 6:10 AM by Ashish Jain
  • Stored procedure can 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.
  • Stored procedures help promote code reuse.
  • Stored procedures can encapsulate logic. You can change stored procedure code without affecting clients.
  • Stored procedures provide better security to your data.
  • Comments