本文共 379 字,大约阅读时间需要 1 分钟。
(Select STUFF(cast((Select '、'+oac.CITY_NAME FROM ORDER_AREA_CITY oacwhere oac.ORDER_AREA_DETAIL_ID = oad.ORDER_AREA_DETAIL_ID FOR XML PATH('')) as varchar(1000)),1,1,'')) as PROV_NAMES,
关键就是这一句,仔细看下就懂了,感觉比较实用:
(Select '、'+oac.CITY_NAME FROM ORDER_AREA_CITY oac
where oac.ORDER_AREA_DETAIL_ID = oad.ORDER_AREA_DETAIL_ID FOR XML PATH('')) as varchar(1000)),1,1,'')) as PROV_NAMES
转载地址:http://aovrj.baihongyu.com/