/SQL/Tsql join multiple record in one string

Tsql join multiple record in one string

-- Concatenates results into one single varchar with separator
SELECT LISTAGG(column_name, ',') WITHIN GROUP (ORDER BY column_name)
FROM YOUR_TABLE;

Tsql join multiple record in one string

Select CountryName from Application.Countries 
 
Declare @val Varchar(MAX); 
Select @val = COALESCE(@val + ', ' + CountryName, CountryName) 
        From Application.Countries Select @val;

Source: mytecbits.com

Similar codes

0 vote285 views1 answer
Sql contains vs like
SQL
0 vote285 views1 answer
Prepared statement mysql java delete selected rows
SQL
0 vote295 views4 answers
Mysql count table rows
SQL
6 votes296 views3 answers
Commit in sql
SQL
4 votes285 views1 answer
Oracle select first 10 rows
SQL
1 vote249 views1 answer
Insert into sql
SQL
1 vote299 views1 answer
Quit mysql
SQL
2 votes278 views1 answer
Drop table purge
SQL
0 vote293 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote286 views1 answer
Mysql set column equal to another automatic
SQL