Chapter 21 -- Creating and Managing Stored Procedures

3 4

Chapter 21

In this chapter, you'll learn about Microsoft SQL Server 2000 stored procedures and how to use them. First we'll look at the types of stored procedures used in SQL Server. Then you'll learn how to create and manage your own stored procedures and how to define parameters and variables. You can use four methods to create stored procedures. This chapter describes how to use Transact-SQL (TSQL), SQL Server Enterprise Manager, and the Create Stored Procedure Wizard. The fourth method of creating stored procedures, using SQL Distributed Management Objects (SQL-DMO), will not be covered here because it pertains to application programming. As you'll see, the three methods explained in this chapter require that you know the same T-SQL code, so pay close attention to the description of the first method, in the section "Using the CREATE PROCEDURE Statement."