2.1.2.151 S201-02, Array as result type of functions

  • Article

V0187:

The specification states the following:

 Subclause 11.60, "<SQL-invoked routine>":
  
 <locator indication> ::=
 AS LOCATOR
  
 ...
  
 <returns clause> ::=
 RETURNS <returns type>
  
 <returns type> ::=
 <returns data type> [ <result cast> ]
 | <returns table type>
  
 ...
  
 <returns data type> ::=
 <data type> [ <locator indication> ]

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

Transact-SQL does not support this feature.