/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

31 votes268 views3 answers
Sql count(*)
SQL
1 vote305 views1 answer
Primary key with prefix sql
SQL
0 vote295 views1 answer
Wordpress database query change url
SQL
0 vote275 views1 answer
How get data from database if id not found then search another column
SQL
0 vote296 views2 answers
Call to undefined function mysql_query()
SQL
1 vote280 views1 answer
Duplicating a MySQL table with all the data Command
SQL
15 votes288 views4 answers
Mysql export database command line
SQL
4 votes337 views4 answers
Check constraint in ms sql
SQL
0 vote275 views1 answer
Laravel eloquent get generated sql
SQL
0 vote278 views1 answer
Varchar format not case sensitive sql
SQL