An Introduction to Triggers

A trigger is a T-SQL statement that SQL Server executes in response to data being edited, inserted, or deleted. Triggers provide you with another way to enforce business rules. They also allow you to perform tasks such as inserting data into an audit log when the user modifies important fields. Chapter 8, “Designing SQL Server Stored Procedures, User-Defined Functions, and Triggers,” covers triggers in detail.

Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.