Stored procedures improve database performance, enhance database security, and bring programming techniques to Transact-SQL not available without this database object. This chapter introduces you to the types of stored procedures available in SQL Server 2000 and how to create, execute, and alter them. The final lesson in this chapter introduces you to programming stored procedures.