SQL server将查询到的多行结果,拼接成字符串(列转行)时间:2023-03-09 03:09:27 select stuff(( select ','+UserName from tabname for xml path('')),1,1,'') as UserNamestr 注释:查询出tabname表中的UserName列的所有内容,并将内容拼接成UserNamestr