select STUFF((select ','+location_id from t_zone_loca where dps_item='xhzlqbzp' ORDER BY location_id for xml path('')),1,1,'')
sqlserver 用 STUFF 和 for xml path 把查询结果连接成字符串
最新推荐文章于 2024-08-09 04:16:12 发布
select STUFF((select ','+location_id from t_zone_loca where dps_item='xhzlqbzp' ORDER BY location_id for xml path('')),1,1,'')