Microsoft SQL Server provides the stored procedure mechanism to simplify the database development process by grouping Transact-SQL statements into manageable blocks.
Precompiled execution: SQL Server compiles each stored procedure once and then reutilises the execution plan. This results in tremendous performance boosts when stored procedures are called repeatedly.
Reduced client/server traffic: Stored procedures can reduce long SQL queries to a single line that is transmitted over the wire.
Efficient reuse of code and programming abstraction: Stored procedures can be used by multiple users and client programs. If utilised in a planned manner, the development cycle takes ...