How to concatenate text from multiple rows into a single text string in SQL server? – ErcanOPAK.com

SQL

How to concatenate text from multiple rows into a single text string in SQL server?

- 19.04.1922.11.19 - ErcanOPAK

STUFF((SELECT ', '+ Column1 FROM Table1 FOR XML PATH('')),1,1,'') AS ConcatenatedColumn

StudentName
-------------
Mary
John
Sam
Alaina
Edward

Result: Mary, John, Sam, Alaina, Edward

Related posts:

SQL Query to Find and Replace text in a stored procedures

How to hide message window in MS SQL Server

Set Identity Insert On/Off in MSSQL

SQL 'string_split()' function

Search text in all tables in SQL Server

Post Views: 121

Leave a Reply Cancel reply