August 2009
Intermediate to advanced
893 pages
26h 48m
English
Content preview from Database Systems: Concepts, Design and Applications
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...