Export (0) Print
Expand All
Expand Minimize

2.1.2.195 T152, DISTINCT predicate with negation

V0231:

The specification states the following:

Subclause 8.15, "<distinct predicate>":

<distinct predicate> ::=
<row value predicand 3> <distinct predicate part 2>

<distinct predicate part 2> ::=
IS [ NOT ] DISTINCT FROM <row value predicand 4>

...

Conformance Rules

Without Feature T152, "DISTINCT predicate with negation", conforming SQL language shall not contain a <distinct predicate part 2> that immediately contains NOT.

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

Transact-SQL does not support this feature.

Show:
© 2014 Microsoft