Explain Stored Procedure

What is Stored Procedure?

A stored procedure is a named group of SQL statements that have been previously created and stored in the server database.

 Stored procedures accept input parameters so that a single procedure can be used over the network by several clients using different input data. And when the procedure is modified, all clients automatically get the new version.

Advantages of using stored procedures are:

• 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.