SQL Sever uses SQL statements to merge duplicate row data into one row and separate them with commas

1、 Define table variables Copy codeThe code is as follows: DECLARE @T1 table ( UserID int , UserName nvarchar(50), CityName nvarchar(50) ); Insert into @ T1 (user ID, user name, city name) values (1, ‘a’,’shanghai ‘)Insert into @ T1 (user ID, user name, city name) values (2, ‘B’,’Beijing ‘)Insert into @ T1 (user ID, user […]