Convert Table Column To Comma Separated String In Sql Server | How To Get Comma Separated Values in Sql Query

In this article i will show you how you can convert table column value into comma separated string. So for this first we will create a new table named as employee.

Now add some record in to the table.

Now here is the query 

Declare @empname varchar(max)

Set @empname=null

SELECT @empname= COALESCE(@empname + ';', '') + Emp_Name  from Employee 

select @empname;

Now run the query and check the output