/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 vote343 views1 answer
Sql replace id with name from another table
SQL
6 votes342 views2 answers
If not exists insert sql
SQL
2 votes332 views2 answers
Get all columns from table sql
SQL
0 vote330 views1 answer
Drop all data from tables
SQL
0 vote358 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
0 vote432 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote356 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
0 vote338 views1 answer
Get the previous column of a table in mysql
SQL
2 votes344 views1 answer
Column names in oracle sql
SQL
2 votes539 views5 answers
Unique in sql server
SQL