/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

1 vote117 views1 answer
Mysql dump specific tables
SQL
5 votes101 views1 answer
Oracle scan source ddl
SQL
5 votes101 views1 answer
Sql add column after another
SQL
9 votes101 views2 answers
Mysql change value
SQL
25 votes99 views5 answers
Date in mysql
SQL
16 votes96 views3 answers
Tsql rename column name
SQL
57 votes258 views5 answers
How to create a new user in postgresql
SQL
0 vote106 views1 answer
Disableforiegn key check
SQL
32 votes104 views6 answers
Sql count where
SQL
0 vote95 views1 answer
How to remove default in mysql
SQL