By using stored procedures we can reuse the code.

Stored procedure helps in reducing network traffic and latency.

Stored procedures provide better security to your data.

Stored procedure is cached in SQL Server’s memory. So it helps to reduce the server overhead. It also enhances application performance.

Stored procedures help us in the encapsulation of the code. The code of the stored procedure can be changed without affecting application.