Answers for "comma separated row values in sql server"

SQL
1

rows to comma separated values in mssql

DECLARE @test NVARCHAR(max)  
SELECT @test = COALESCE(@test + ',', '') + field2 FROM #test
SELECT field2 = @test
Posted by: Guest on June-16-2020
1

convert rows to string sql server

Select CountryName from Application.Countries 
 
Declare @val Varchar(MAX); 
Select @val = COALESCE(@val + ', ' + CountryName, CountryName) 
        From Application.Countries Select @val;
Posted by: Guest on June-01-2020

Code answers related to "comma separated row values in sql server"

Code answers related to "SQL"

Browse Popular Code Answers by Language