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.
V0180:
The specification states the following:
-
Subclause 10.9, "<aggregate function>": <array aggregate function> ::= ARRAY_AGG <left paren> <value expression> [ ORDER BY <sort specification list> ] <right paren> ... Conformance Rules Without Feature S098, "ARRAY_AGG", conforming SQL language shall not contain an <array aggregate function>.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.