Can Microsoft define a "listag" function in SQL SERVER

Copper Contributor

SQL server does not support integrated queries that convert a column of data into a single cell, and must use the For XML method. However, this method is not very easy to use. We hope that Microsoft can learn from ORACLE and add a function like 'listag' to facilitate developers' development

1 Reply

@GoodForNothing You are not up-to-date, we have a string aggregation in SQL Server.

STRING_AGG (Transact-SQL) - SQL Server | Microsoft Learn