–转化为xml格式,去掉根节点,形成一行
–select ‘,’+(field009)+’-‘+(field010) from ufv2m7k41656039640871 where field007<0 order by field010 asc for xml path(”)
select STUFF((select ‘,’+(field009)+’-‘+(field010) from ufv2m7k41656039640871 where field007<0 order by field010 desc), 1, 1, ‘ ‘)
原创文章,作者:wure,如若转载,请注明出处:https://blog.ytso.com/277968.html