select ‘‘‘‘+SUBSTRING( b.id,2,len(b.id))+‘‘‘‘ from ( select (stuff(( select ‘‘‘,‘‘‘ +t.sysserialno from ( select * from sdshippkitem where orderno = ‘0200186943‘ ) t for xml path(‘‘)),1,1,‘‘)) id) b
SqlServer实现Oracle的wm_concat()函数功能
原文:https://www.cnblogs.com/wangjp-1233/p/13282380.html
如果您也喜欢它,动动您的小指点个赞吧