Alison Balter's Mastering Access 2002 Enterprise Development

Chapter 8. Designing SQL Server Stored Procedures, User-Defined Functions, and Triggers

IN THIS CHAPTER

• Why This Chapter Is Important

• Stored Procedure Basics

• Declaring and Working with Variables

• Controlling the Flow

• The SET NOCOUNT Statement

• Using the @@Functions

• Working with Parameters

• Modifying Data with Stored Procedures

• Errors and Error Handling

• Stored Procedures and Transactions

• Stored Procedures and Temporary Tables

• Stored Procedures and Security

• Debugging the Stored Procedures That You Build

• Building and Working with User-Defined Functions

• Creating and Working with Triggers