–转化为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/tech/database/277968.html