O'Reilly logo

Database Systems: Concepts, Design and Applications by S. K. Singh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

25.3. Stored Procedures in SQL Server

Microsoft SQL Server provides the stored procedure mechanism to simplify the database development process by grouping Transact-SQL statements into manageable blocks.

25.3.1. Benefits of Stored Procedures

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required