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:

How to solve “A cursor with the name already exists” problem?
How to check if recursive triggers are enabled in SQL
How to reset identity seed after deleting records in SQL
How to solve 'incorrect syntax near the keyword WITH' problem?
Post Views: 123

Leave a Reply

Your email address will not be published. Required fields are marked *