MCSE Training Kit (Exam 70-229): Microsoft SQL Server(TM) 2000 Database Design and Implementation (Pro Certification)
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."