F571, Truth value tests


The specification states the following:

 Subclause 6.35, "<boolean value expression>":
 <boolean test> ::=
 <boolean primary> [ IS [ NOT ] <truth value> ]
 <truth value> ::=
 <boolean primary> ::=
 | <boolean predicand>
 Conformance Rules
 Without Feature F571, "Truth value tests", conforming SQL language shall not contain a <boolean test> that simply contains a <truth value>.

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

Transact-SQL does not support this feature.