Tuesday, March 29, 2011

Important about Triggers from bol

At most, one INSTEAD OF trigger per INSERT, UPDATE, or DELETE statement can be defined on a table or view.

INSTEAD OF triggers are not allowed on updatable views that use WITH CHECK OPTION.

Mutliple triggers are allowed in SQL server .

Order of multiple triggers is random in general,  however, the first and last trigger can be set using
Sp_settriggerorder. This sp can decide only  the first and last trigger.
Recursion in trigger is allowed, e.g. an update trigger may fire itself by updating its own table.
But this requires RECURSIVE_TRIGGERS setting of the database to be set.
INSTEAD OF Triggers cannot be recursive and there can not multiple instead of trigger for a single operation i.e. UPDATE,DELETE , INSERT .

No comments:

Post a Comment