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.
V0175:
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> ... <path-resolved user-defined type name> ::= <user-defined type name> ... <array type> ::= <data type> ARRAY [ <left bracket or trigraph> <maximum cardinality> <right bracket or trigraph> ] ... Conformance Rules Without Feature S092, "Arrays of user-defined types", conforming SQL language shall not contain an <array type> that is based on a <data type> that contains a <path-resolved user-defined type name>.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.