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.
V0203:
The specification states the following:
-
Subclause 7.6, "<table reference>": <collection derived table> ::= UNNEST <left paren> <collection value expression> [ { <comma> <collection value expression> }... ] <right paren> [ WITH ORDINALITY ] ... Conformance Rules Without Feature S301, "Enhanced UNNEST", in conforming SQL language, a <collection derived table> shall not simply contain more than one <collection value expression>.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.