您也可以使用XML PATH
(在线演示)
SELECT id1,
id2,
id3,
id4,
id5,
new_col = CONCAT('/', ids)
FROM YourTable
CROSS APPLY (SELECT CONCAT(id, '/')
FROM (VALUES (id1),
(id2),
(id3),
(id4),
(id5)) V(id)
ORDER BY id
FOR XML PATH('')) C(ids)