查询表: id title 1 title1 2 title2 3 title3 要求现实: title1,title2,title3 select stuff((select ','+title from tb for xml path('')),1,1,'')
查询表:
id title
1 title1
2 title2
3 title3
要求现实:
title1,title2,title3
select stuff((select ','+title from tb for xml path('')),1,1,'')