Trigger Enhancements in SQL Server 2000
SQL Server 2000 includes exciting new features for triggers. Some of these features are discussed later in this chapter, but here we want to mention them briefly.
In previous versions, you were forced to use triggers to implement cascading operations. SQL Server 2000 provides cascade declarative referential integrity by FOREIGN KEY constraints with the ON DELETE CASCADE and ON UPDATE CASCADE options, as explained in Chapter 7. This is the recommended way to implement cascade operations.
SQL Server 2000 provides a new type of trigger: the INSTEAD OF trigger. These triggers are executed instead of the firing actions, providing a mechanism to check for data changes before the data is actually modified. ...
Get Microsoft® SQL Server™ 2000 Programming by Example 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.
