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.
V0222:
The specification states the following:
-
Subclause 5.4, "Names and identifiers": <field name> ::= <identifier> ... Conformance Rules Without Feature T051, "Row types", conforming SQL language shall not contain a <field name>. Subclause 6.1, "<data type>": <row type> ::= ROW <row type body> <row type body> ::= <left paren> <field definition> [ { <comma> <field definition> }... ] <right paren> ... Conformance Rules Without Feature T051, "Row types", conforming SQL language shall not contain a <row type>. Subclause 6.2, "<field definition>": <field definition> ::= <field name> <data type> ... Conformance Rules Without Feature T051, "Row types", conforming SQL language shall not contain a <field definition>. Subclause 6.15, "<field reference>": <field reference> ::= <value expression primary> <period> <field name> ... Conformance Rules Without Feature T051, "Row types", conforming SQL language shall not contain a <field reference>. Subclause 7.1, "<row value constructor>": <explicit row value constructor> ::= <left paren> <row value constructor element> <comma> <row value constructor element list> <right paren> | ROW <left paren> <row value constructor element list> <right paren> | <row subquery> ... <contextually typed row value constructor> ::= <common value expression> | <boolean value expression> | <contextually typed value specification> | <left paren> <contextually typed value specification> <right paren> | <left paren> <contextually typed row value constructor element> <comma> <contextually typed row value constructor element list> <right paren> | ROW <left paren> <contextually typed row value constructor element list> <right paren> ... Conformance Rules Without Feature T051, "Row types", conforming SQL language shall not contain an <explicit row value constructor> that immediately contains ROW. Without Feature T051, "Row types", conforming SQL language shall not contain a <contextually typed row value constructor> that immediately contains ROW. Subclause 7.2, "<row value expression>": <row value special case> ::= <nonparenthesized value expression primary> ... Conformance Rules Without Feature T051, "Row types", conforming SQL language shall not contain a <row value special case>. Subclause 7.12, "<query specification>": <all fields reference> ::= <value expression primary> <period> <asterisk> [ AS <left paren> <all fields column name list> <right paren> ] ... Conformance Rules Without Feature T051, "Row types", conforming SQL language shall not contain an <all fields reference>.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.