Advantages of Stored procedure

                            Advantages of Stored procedure 
-Stored procedure can reduced network traffic and latency, boosting application performance.
-Stored procedure execution plans can be reused; they 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.