What are the advantages of using Stored Procedures?

- They help in reducing the network traffic and latency which in turn boosts application performance. 
- They help in promoting code reuse. 
- They provide better security to data. 
- It is possible to encapsulate the logic using stored procedures. This allows to change stored procedure code without affecting clients. 
- It is possible to reuse stored procedure execution plans, which are cached in SQL Server's memory. This reduces server overhead.