Trigger constants enumerate the kind of Transact-SQL data modification statement that will cause a trigger to fire.
Microsoft® SQL Server™ cursors may fire when an INSERT, UPDATE, or DELETE statement modifies data in a table on which an enabled trigger is defined. Separate triggers may be created to implement behavior for any one or a combination of Transact-SQL DML statements.
| Constant | Value | Description |
|---|---|---|
| SQLDMOTrig_All | 7 | Trigger is fired by any data modification statement |
| SQLDMOTrig_Delete | 4 | Trigger is fired by a DELETE statement |
| SQLDMOTrig_Insert | 1 | Trigger is fired by an INSERT statement |
| SQLDMOTrig_Unknown | 0 | Bad or invalid value |
| SQLDMOTrig_Update | 2 | Trigger is fired by an UPDATE statement |