Chapter 8 -- Implementing Stored Procedures

3 4

Chapter 8

Implementing Stored Procedures

About This Chapter

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.

Before You Begin

To complete the lessons in this chapter, you must have:

• SQL Server 2000 Enterprise Edition installed on a Windows 2000 Server computer.
• The ability to log on to the Windows 2000 Server computer and to SQL Server as the Windows 2000 Administrator.
• Completed the exercises in Chapter 3, "Designing a SQL Server Database," Chapter 4, "Implementing SQL Server Databases and Tables," and Chapter 5, "Implementing Data Integrity."