String_agg for SQL Server before 2017

by

In SQL Server pre-2017, you can do:

select stuff( (select ',' + cast(t.id as varchar(max))
               from tabel t
               for xml path ('')
              ), 1, 1, ''
            );

The only purpose of stuff() is to remove the initial comma. The work is being done by for xml path.

More Related Contents:

  1. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  2. How do I create a comma-separated list using a SQL query?
  3. Produce DISTINCT values in STRING_AGG
  4. Get unique values using STRING_AGG in SQL Server
  5. Convert text to system date format [duplicate]
  6. How to get a particular preceding value of a column in SQL [closed]
  7. How to select just the row in the second table?
  8. How do I obtain a Query Execution Plan in SQL Server?
  9. SQL update from one Table to another based on a ID match
  10. What is the meaning of the prefix N in T-SQL statements and when should I use it?
  11. Remove Identity from a column in a table
  12. Why no windowed functions in where clauses?
  13. efficient way to implement paging
  14. SQL Server – transactions roll back on error?
  15. T-SQL Cast versus Convert
  16. SQL Case Sensitive String Compare
  17. Exporting data In SQL Server as INSERT INTO
  18. convert Excel Date Serial Number to Regular Date
  19. Convert Comma Separated column value to rows
  20. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  21. Partition Function COUNT() OVER possible using DISTINCT
  22. What does sp_reset_connection do?
  23. Replace first occurrence of substring in a string in SQL
  24. How to correctly insert newline in nvarchar [duplicate]
  25. How do you copy a record in a SQL table but swap out the unique id of the new row?
  26. Using IF ELSE statement based on Count to execute different Insert statements
  27. SQL – How do I get only the numbers after the decimal?
  28. How to retrieve records for last 30 minutes in MS SQL?
  29. Connecting to Oracle Database using Sql Server Integration Services
  30. Executing SQL query on multiple databases

Leave a Comment