2.1.2.137 S091-02, Arrays of distinct types

V0173:

The specification states the following:

 Subclause 6.38, "<array value constructor>":
  
 <array value constructor by enumeration> ::=
 ARRAY <left bracket or trigraph> <array element list> <right bracket or trigraph>
  
 <array element list> ::=
 <array element> [ { <comma> <array element> }... ]
  
 <array element> ::=
 <value expression>
  
 Subclause 6.26, "<value expression>":
  
 <value expression> ::=
 <common value expression>
 | <boolean value expression>
 | <row value expression>
  
 <common value expression> ::=
 |<numeric value expression>
 |<string value expression>
 |<datetime value expression>
 |<interval value expression>
 |<user-defined type value expression>
 |<reference value expression>
 |<collection value expression>

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL does not support this feature.