The trigger event specifies the data manipulation statement that will cause the trigger to execute. The possible values for the trigger event are:
A statement trigger will be executed once each time the specified data manipulation statement is executed on the table on which the trigger was created.
A row trigger will be executed once for each row affected when the specified data manipulation statement is executed on the table on which the trigger was created.
Note: If the trigger time is INSTEAD OF, the trigger event itself has no effect on the table (view), it just causes the trigger to execute. The environment executing the trigger event behaves as if the data manipulation statement is actually being executed, even though no changes actually occur in the table(s) that would normally be affected. The only data manipulations possible in this case are those performed by the trigger action.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40