O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Triggers

Triggers are a special variant of stored procedures that are linked to tables and executed when the event for which they are programmed occurs. There are three variants of triggers in SQL Server 7/MSDE: INSERT, UPDATE, and DELETE. SQL Server 2000/MSDE 2000 also introduces INSTEAD OF and AFTER triggers.

To create, change, or delete a trigger for a table, first select the corresponding table in the Database window. Right-click the table name and select Triggers from the shortcut menu.

Tables can include any number of triggers, which can be created using the Trigger Name combo box shown in Figure 8-14.

Figure 8-14. Creating a trigger

Note

Remember that problems can occur if one trigger sets off another trigger in turn by updating ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required