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.
V0133:
The specification states the following:
-
Subclause 11.8, "<referential constraint definition>": <referential triggered action> ::= <update rule> [ <delete rule> ] | <delete rule> [ <update rule> ] <update rule> ::= ON UPDATE <referential action> <delete rule> ::= ON DELETE <referential action> ... Conformance Rules Without Feature F701, "Referential update actions", conforming SQL language shall not contain an <update rule>.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL partially supports this feature. See the ON UPDATE clause and related clauses of the CREATE TRIGGER [MSDN-CTGTS] and ALTER TRIGGER [MSDN-ALTERTRIGGER] statements for equivalent functionality.