SQL Server - Return Comma Separated Column Value

In this article you will learn Return Comma Separated column value in SQL Server.

In SQL Server I have a table like below:



Now I want to return Name Column value as comma separated using SQL Server statement:

SELECTSTUFF((SELECTDISTINCT', '+CAST(Name ASVARCHAR(100))
FROM Emp_Information FORXMLPATH('')),1,2,'')AS Employees