sql用逗号隔开

 

--(1,2,3,,,,,,)
select stuff((select ',' +convert(varchar,opid) FROM o_workreport_remark where id=14
GROUP BY opid for xml path('')),1,1,'')

 

posted @ 2021-12-15 13:50  丶Ronnie  阅读(92)  评论(0)    收藏  举报