2.1.1.10 E051, Basic query specification
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).