SqlServer实现Oracle的wm_concat()函数功能
标签：sel color select order code rom serial for concat
SqlServer实现Oracle的wm_concat()函数功能
‘‘‘‘+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