2.1.2.91 F672, Retrospective check constraints

V0127:

The specification states the following:

 Subclause 11.9, "<check constraint definition>":
  
 <check constraint definition> ::=
 CHECK <left paren> <search condition> <right paren>
  
 ...
  
 Conformance Rules
  
 Without Feature F672, "Retrospective check constraints", conforming SQL language shall not contain a <check constraint definition> that generally contains CURRENT_DATE, CURRENT_TIMESTAMP, or LOCALTIMESTAMP.
  
 Subclause 11.4, "<column definition>":
  
 <column constraint> ::=
 NOT NULL
 | <unique specification>
 | <references specification>
 | <check constraint definition>
  
 Subclause 11.6, "<table constraint definition>":
  
 <table constraint> ::=
 <unique constraint definition>
 | <referential constraint definition>
 | <check constraint definition>
  
 Subclause 11.34, "<domain definition>":
  
 <domain constraint> ::=
 [ <constraint name definition> ] <check constraint definition> [
 <constraint characteristics> ]
  
  
 Subclause 11.47, "<assertion definition>":
  
 <assertion definition> ::=
 CREATE ASSERTION <constraint name>
 CHECK <left paren> <search condition> <right paren>
 [ <constraint characteristics> ]
  
 ...
  
 Conformance Rules
  
 Without Feature F672, "Retrospective check constraints", conforming SQL language shall not contain an <assertion definition> that generally contains CURRENT_DATE, CURRENT_TIMESTAMP, or LOCALTIMESTAMP.
  
 Subclause 8.21, "<search condition>":
  
 <search condition> ::=
 <boolean value expression>

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

Transact-SQL does not support this feature.