按顺序连接字段-SQL Server

您也可以使用

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)