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.
V0176:
The specification states the following:
-
Subclause 6.1, "<data type>": <data type> ::= <predefined type> | <row type> | <path-resolved user-defined type name> | <reference type> | <collection type> ... <reference type> ::= REF <left paren> <referenced type> <right paren> [ <scope clause> ] ... <array type> ::= <data type> ARRAY [ <left bracket or trigraph> <maximum cardinality> <right bracket or trigraph> ] ... Conformance Rules Without Feature S094, "Arrays of reference types", conforming SQL language shall not contain an <array type> that is based on a <data type> that contains a <reference type>.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.