2.1.2.214 T212, Enhanced trigger capability

V0250:

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>
  
 ...
  
 Conformance Rules
  
 Without Feature T212, "Enhanced trigger capability", in conforming SQL language, a <triggered action> shall contain FOR EACH ROW.

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL does not support this feature. Transact-SQL does not support FOR EACH ROW triggers in general (see feature T211-04, section 2.1.2.209).

See [ISO/IEC9075-1:2011] for the definition of "trigger".