sql表中某个字段拼接

 

(SELECT STUFF((SELECT ',' + LTRIM(RTRIM(D.VehicleID)) FROM JDSN.OrderVehicle D
WHERE D.OrgID=@OrgID AND D.OrderID=A.OrderID
FOR XML PATH('')), 1, 1, '')) AS VehicleIDs,

posted @ 2021-07-05 14:10  紫心落  阅读(394)  评论(0)  编辑  收藏  举报