create table tb(id int, value varchar(10))
insert into tb values(1, 'aa')
insert into tb values(1, 'bb')
insert into tb values(2, 'aaa')
insert into tb values(2, 'bbb')
insert into tb values(2, 'ccc')
go
SELECT * from tb;
select id, [value] = stuff((select ',' + [value] from tb t where id = tb.id for xml path('')) , 1 , 1 , '')
from tb
group by id
drop table tb
以上就是sql server 怎么实现mysql中group_concat,列转行,列用分隔符拼接字符串的详细内容，更多关于sql server 怎么实现mysql中group_concat,列转行,列用分隔符拼接字符串的资料请关注九品源码其它相关文章！