Discussion Board

Statement trigger A statement trigger is fired once on behalf of the triggering statement, regardless of the number of rows in the table that the triggering statement affects, even if no rows are affected. For example, if a DELETE statement deletes several rows from a table, a statement-level DELETE trigger is fired only once. Statement triggers are useful if the code in the trigger action does not depend on the data provided by the triggering statement or the rows affected. For example, use a statement trigger to: - Make a complex security check on the current time or user. - Generate a single audit record. Prajakta Pandit 02-21-2017 05:33 AM

Write your comments

*

* Email must be in the form someone@domain.com

*

*