2.1.2.242 T551, Optional key words for default syntax

V0278:

The specification states the following:

 Subclause 7.13, "<query expression>":
  
 <query expression body> ::=
 <query term>
 | <query expression body> UNION [ ALL | DISTINCT ]
 [ <corresponding spec> ] <query term>
 | <query expression body> EXCEPT [ ALL | DISTINCT ]
 [ <corresponding spec> ] <query term>
  
 <query term> ::=
 <query primary>
 | <query term> INTERSECT [ ALL | DISTINCT ]
 [ <corresponding spec> ] <query primary>
  
 ...
  
 Conformance Rules
  
 Without Feature T551, "Optional key words for default syntax", conforming SQL language shall not contain UNION DISTINCT, EXCEPT DISTINCT, or INTERSECT DISTINCT.
  
 Subclause 14.2, "<cursor properties>":
  
 <cursor properties> ::=
 [ <cursor sensitivity> ] [ <cursor scrollability> ] CURSOR
 [ <cursor holdability> ]
 [ <cursor returnability> ]
  
 ...
  
 <cursor holdability> ::=
 WITH HOLD
 | WITHOUT HOLD
  
 ...
  
 Conformance Rules
  
 Without Feature T551, "Optional key words for default syntax", conforming SQL language shall not contain a <cursor holdability> that immediately contains WITHOUT HOLD.

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

Transact-SQL does not support this feature. See the EXCEPT, INTERSECT [MSDN-EXCEPTINTERSECT], and UNION [MSDN-UNION] operators without the DISTINCT keyword for equivalent functionality.