sql多列值一行显示

 select stuff(( select ',' + UserNM from tblSysUser for xml path('')), 1,1,'')

原文地址:https://www.cnblogs.com/dongjh/p/11454558.html