Chapter 12. Stored Procedures
After completing this chapter, you will be able to
Create stored procedures
Specify input/output parameters
Work with variables
Build structured error-handling routines
If you were to look for the workhorse object within SQL Server, it would be a stored procedure. Stored procedures provide the backbone and database interface for virtually every SQL Server application in the world. In this chapter, you will learn how to create stored procedures to manage your environment as well as provide the programmatic interface necessary for writing easily maintained and efficient database applications. All of the code examples contained in this chapter, unless noted, can be found in the Chapter12\code1.sql file in the book’s accompanying ...
Get Microsoft® SQL Server® 2008 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.
