Advantages of Stored Procedure in Microsoft SQL Server

There are many advantages of using stored procedures in Microsoft SQL Server. These are :

1. Easier to maintain and troubleshoot as they are modular.
2. Stored procedures enable better tuning for performance.
3. While using stored procedures is much easier from a GUI end than building complex queries.
4. Stored procedures help in reducing network usage.
5. Stored procedures provide more scalability to an application.
6. Reusable and hence reduce code.
7. Stored procedures can be part of a separate layer which allows separating the concerns. Hence Database layer can be handled by separate developers proficient in database queries.

See Also