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.
V0128:
The specification states the following:
-
Subclause 8.21, "<search condition>": <search condition> ::= <boolean value expression> Subclause 10.4, "<routine invocation>": <routine invocation> ::= <routine name> <SQL argument list> Subclause 11.9, "<check constraint definition>": <check constraint definition> ::= CHECK <left paren> <search condition> <right paren> ... Conformance Rules: Without Feature F673, "Reads SQL-data routine invocations in CHECK constraints", conforming SQL language shall not contain a <check constraint definition> that contains a <search condition> that generally contains a <routine invocation> whose subject routine is an SQL routine that possibly reads SQL-data.
Microsoft SQL Server 2008 R2varies as follows:
This feature is absent from the [ISO/IEC9075-2:2008]standard.
Microsoft SQL Server 2012 varies as follows:
Transact-SQL partially supports this feature. The syntax differs from the standard.