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

SQL

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

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

Result: Mary, John, Sam, Alaina, Edward

Why SELECT * Slowly Destroys Performance

Post Views: 128