很实用的一个功能,环境准备
drop table ta;
create table ta (id int identity(1,1) not null primary key,name varchar(10),value varchar(20));
insert into ta values('a','beij');
insert into ta values('a','shangh');
insert into ta values('b','shenz');
insert into ta values('b','chongq');
实验:
select ',' + ta.value
from ta for xml path;
select ','+ value
from ta for xml path('');
select *
from ta for xml path('row');
select *
from ta for xml path('');