Share via


2.1.2.209 T211-04, FOR EACH ROW triggers

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.