利用select for xml 生成以逗号分隔的字符串

DECLARE @T1 table(UserID int , UserName nvarchar(50),CityName nvarchar(50)); 
insert into @T1 (UserID,UserName,CityName) values (1,'a','上海') 
insert into @T1 (UserID,UserName,CityName) values (2,'b','北京') 
insert into @T1 (UserID,UserName,CityName) values (3,'c','上海') 
insert into @T1 (UserID,UserName,CityName) values (4,'d','北京') 
insert into @T1 (UserID,UserName,CityName) values (5,'e','上海') 
SELECT UserName+',' FROM @T1 FOR XML PATH('')

 

深圳A8数据分析处理工作室

咨询热线：

１３７-１４３-４００-９９

 地址：深圳市南山区科技园南区软件园 http://www.HiA8.cn