Share via


2.1.2.188 T053, Explicit aliases for all-fields reference

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.