SQL中stuff使用
select name + ',' + str(id) from A for xml path
select name ,id from A for xml path
select top 5* from A
select
name,
des = (
stuff(
(select ',' + des from A where name = s.name for xml path('')),
1,
1,
''
)
)
from A as s group by name
关联博客:https://www.cnblogs.com/stevenjson/p/3673239.html
stuff把拼接的内容的第一个“,”去掉