MSSQL sqlserver将查询的单列结果集拼成一行字符串用逗号分隔

select stuff((select ','+ cast(appuserid as nvarchar(50))  from T_appUser_community where communityid=2 for xml path('')),1,1,'')


© 2016-2024 阿尔佛 aerfo.com | 豫ICP备17044542号 | 豫公网安备 41010602000172