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.19 | 22.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:

Get a Tree view with SQL Query

How to get stored procedure parameters details in SQL

Rename column SQL Server

Get the User Name and Domain Name from an Email Address in SQL

Post Views: 123

Leave a Reply Cancel reply