Chapter 17. Stored procedures
After completing this chapter, you will be able to
Understand stored procedures.
Work with stored procedures.
Create, alter, and delete stored procedures.
Use different types of parameters with stored procedures.
Stored procedures are a set of SQL statements (one or more) typically grouped together to perform a specific routine. Stored procedures can be created in any user-defined database and system database except the resource database. They are comparable to multistatement functions, but they boast features and flexibilities that are not possible within functions. Some of the benefits of using stored procedures are as follows:
They offer improved performance because of compiled code.
They are easy to maintain because ...
Get Microsoft® SQL Server® 2012 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
