O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

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

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. ...

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