SQL-Server Triggers  «Prev 

1) trigger_name is the name of the trigger you are going to modify. A trigger is a database object, so it must have a unique name within the database.

2) table is the name of the table on which you will modify the trigger.

3) WITH ENCRYPTION encrypts the text so that it can not be read from the syscomments table.

4) trigger_type is the type of trigger you wish the trigger to become. The type can be INSERT, UPDATE, or DELETE, depending on the type you want the trigger to become.

5) WITH APPEND is an optional statement that indicates to SQL Server that if a trigger of the same type already exists, this trigger should be added.

6) NOT FOR REPLICATION indicates that any replication operations that affect data in the table should not fir the trigger. The code should affect the data anyway,

7) column is used if you wish to test for a specific column to have data inserted or updated into it. Multiple columns can be specified.

8) Bitwise_operator, updated_bitmask, comparison_operator, and column_bitmask all are affected by the COLUMNS_UPDATED clause, which is used to test a bit-filed representing one or more columns that are updated.

9) trigger_code is the Transact-SQL code that you will use to implement your business rules, using the INSERTED and DELETED special trigger tables.