Example:
Ram
shyam
Golu
Chintu
(This query will give space only)
DECLARE @Str varchar(max)
SELECT @Str=COALESCE(@Str,'') + CAST(ColumnName as varchar(100)) + ' '
FROM TableName
SELECT @Str
(This query will give comma(,)
DECLARE @Str varchar(max)
SELECT @Str=COALESCE(@Str,'') + CAST(ColumnName as varchar(100)) + ','
FROM TableName
SELECT @Str
Output:
Ram,Shyam,Golu,Chintu
Sql Server comma separated(,)
How to get column values as comma separated list in SQL Server.
Join the conversation! Your thoughts help the community grow.