Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
V0245:
The specification states the following:
-
Subclause 11.49, "<trigger definition>": <trigger definition> ::= CREATE TRIGGER <trigger name> <trigger action time> <trigger event> ON <table name> [ REFERENCING <transition table or variable list> ] <triggered action> ... <triggered action> ::= [ FOR EACH { ROW | STATEMENT } ] [ <triggered when clause> ] <triggered SQL statement> ... Syntax Rules Let OR, OT, NR, and NT be the <old transition variable name>, <old transition table name>, <new transition variable name>, and <new transition table name>, respectively. ... If neither FOR EACH ROW nor FOR EACH STATEMENT is specified, then FOR EACH STATEMENT is implicit. If OR or NR is specified, then FOR EACH ROW shall be specified.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.