You can create comma separated, concatenated strings from values in columns in a database. The concatenated strings are separated by a separator which gets added except for the end of the string.
The full syntax is here:
STRING_AGG ( expression, separator ) [ <order_clause> ]
<order_clause> ::=
WITHIN GROUP ( ORDER BY <order_by_expression_list> [ ASC | DESC ] )
If you have SQL Server 2016, this will not work as shown here.
But it does recognize it as a function because I am using SQL Server Management Studio v17
Why not download SQL Server 2017 RC2 and try?
The full syntax is here:
STRING_AGG ( expression, separator ) [ <order_clause> ]
<order_clause> ::=
WITHIN GROUP ( ORDER BY <order_by_expression_list> [ ASC | DESC ] )
If you have SQL Server 2016, this will not work as shown here.
But it does recognize it as a function because I am using SQL Server Management Studio v17
Why not download SQL Server 2017 RC2 and try?
No comments:
Post a Comment