/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

17 votes348 views6 answers
Sql select distinct
SQL
1 vote342 views2 answers
DROP TABLes regardless of constraints
SQL
2 votes360 views2 answers
Compare date mysql
SQL
6 votes405 views6 answers
Rename column postgres
SQL
3 votes387 views1 answer
Query less than datetime sql
SQL
3 votes317 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
1 vote333 views2 answers
Mysql does sentance contain word
SQL
0 vote329 views1 answer
Access refused mysql xampp server
SQL
0 vote362 views1 answer
Proc sql not in working
SQL
0 vote353 views1 answer
Mysql utc timestamp
SQL