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,

原文地址:https://www.cnblogs.com/luoxiaoxiao102/p/14972154.html