Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
V0224:
The specification states the following:
-
Subclause 7.6, "<table reference>": <column name list> ::= <column name> [ { <comma> <column name> }... ] Subclause 7.12, "<query specification>": <all fields column name list> ::= <column name list> ... Conformance Rules Without Feature T053, "Explicit aliases for all-fields reference", conforming SQL language shall not contain an <all fields column name list>. NOTE — If a <set quantifier> DISTINCT is specified, then the Conformance Rules of Subclause 9.12, "Grouping operations", also apply. Subclause 9.12, "Grouping operations": Conformance Rules Without Feature S024, "Enhanced structured types", in conforming SQL language, the declared type of an operand of a grouping operation shall not be ST-ordered. Subclause 10.9, "<aggregate function>": <set quantifier> ::= DISTINCT | ALL
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.