将多行结果用一行一列加逗号分隔查询出来。多行sql如下
select UserName from userinfo group by UserName
查询的结果如下图
实现用逗号分隔的sql语句如下
select stuff((select ',''' +UserName+'''' from userinfo group by UserName for xml path('')),1,1,'')
查询的结果如下图
将多行结果用一行一列加逗号分隔查询出来。多行sql如下
select UserName from userinfo group by UserName
查询的结果如下图
实现用逗号分隔的sql语句如下
select stuff((select ',''' +UserName+'''' from userinfo group by UserName for xml path('')),1,1,'')
查询的结果如下图