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.
V0188:
The specification states the following:
-
Subclause 10.4, "<routine invocation>": <SQL argument> ::= <value expression> | <generalized expression> | <target specification> <generalized expression> ::= <value expression> AS <path-resolved user-defined type name> ... Conformance Rules Without Feature S202, "SQL-invoked routines on multisets", conforming SQL language shall not contain an <SQL argument> whose declared type is a multiset type. Subclause 11.60, "<SQL-invoked routine>": <parameter type> ::= <data type> [ <locator indication> ] ... <returns data type> ::= <data type> [ <locator indication> ] ... Conformance Rules Without Feature S202, "SQL-invoked routines on multisets", conforming SQL language shall not contain a <parameter type> that is based on a multiset type. Without Feature S202, "SQL-invoked routines on multisets", conforming SQL language shall not contain a <returns data type> that is based on a multiset type.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.