Share via


2.1.2.149 S201, SQL routines on arrays

V0185:

The specification states the following:

 Subclause 10.4, "<routine invocation>":
  
 Conformance Rules
  
 Without Feature S201, "SQL routines on arrays", conforming SQL language shall not contain an <SQL argument> whose declared type is an array type.
  
 Subclause 11.60, "<SQL-invoked routine>":
  
 Conformance Rules
  
 Without Feature S201, "SQL routines on arrays", conforming SQL language shall not contain a <parameter type> that is based on an array type.
  
 Without Feature S201, "SQL routines on arrays", conforming SQL language shall not contain a <returns data type> that is based on an array type.

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

Transact-SQL does not support this feature.