how to get comma separated values in sql code example

Example 1: sql server: select column values as comma separated string

DECLARE @SQL AS VARCHAR(8000)
SELECT @SQL = ISNULL(@SQL+',','') + ColumnName FROM TableName
SELECT @SQL

Example 2: rows to comma separated values in mssql

DECLARE @test NVARCHAR(max)  
SELECT @test = COALESCE(@test + ',', '') + field2 FROM #test
SELECT field2 = @test

Tags:

Sql Example

Related