sql 里面拼接字符串,返回给前台一个以逗号隔开的字符串

stuff((select  ','+bz (要查询的字段名)  from t_qjgl_qjdjxq b where a.id=b.qjdjid for xml path('')),1,1,'') AS bz

效果