2.1.1.10 E051, Basic query specification

  • Article
  • 2 minutes to read

V0010:

The specification states the following:

 Subclause 7.12, "<query specification>":
  
 <query specification> ::=
 SELECT [ <set quantifier> ] <select list> <table expression>
  
 <select list> ::=
 <asterisk>
 | <select sublist> [ { <comma> <select sublist> }... ]
  
 <select sublist> ::=
 <derived column>
 | <qualified asterisk>
  
 <qualified asterisk> ::=
 <asterisked identifier chain> <period> <asterisk>
 | <all fields reference>
  
 <asterisked identifier chain> ::=
 <asterisked identifier> [ { <period> <asterisked identifier> }... ]
  
 <asterisked identifier> ::=
 <identifier>
  
 <derived column> ::=
 <value expression> [ <as clause> ]
  
 <as clause> ::=
 [ AS ] <column name>
  
 <all fields reference> ::=
 <value expression primary> <period> <asterisk>
 [ AS <left paren> <all fields column name list> <right paren> ]
  
 <all fields column name list> ::=
 <column name list>

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

Transact-SQL partially supports this feature. Transact-SQL supports all of feature E051's subfeatures except E051-09 (section 2.1.1.11).