Share via


2.1.2.92 F673, Reads SQL-data routine invocations in CHECK constraints

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.