Microsoft® SQL Server 2008 R2 Unleashed

Chapter 28. Creating and Managing Stored Procedures

IN THIS CHAPTER

• What’s New in Creating and Managing Stored Procedures

• Advantages of Stored Procedures

• Creating Stored Procedures

• Executing Stored Procedures

• Deferred Name Resolution

• Viewing Stored Procedures

• Modifying Stored Procedures

• Using Input Parameters

• Using Output Parameters

• Returning Procedure Status

• Debugging Stored Procedures Using SQL Server Management Studio

• Using System Stored Procedures

• Startup Procedures

A stored procedure is one or more SQL commands stored in a database as an executable object. Stored procedures can be called interactively, from within client application code, from within other stored procedures, and from within triggers. Parameters ...