Share via


2.1.2.169 S402, Distinct types based on multiset types

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.