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.
V0205:
The specification states the following:
-
Subclause 6.1, "<data type>": <collection type> ::= <array type> | <multiset type> ... <multiset type> ::= <data type> MULTISET [Subclause 6.1] Subclause 11.51, "<user-defined type definition>": <representation> ::= <predefined type> | <collection type> | <member list> ... Conformance Rules: Without Feature S402, "Distinct types based on multiset types", in conforming SQL language, epresentation> shall not contain <multiset type>.
Microsoft SQL Server 2008 R2 varies as follows:
This feature is absent from the [ISO/IEC9075-2:2008] standard.
Microsoft SQL Server 2012 varies as follows:
Transact-SQL does not support this feature.