SELECT UserId, RoleName = stuff(
(
SELECT ‘,’ + RoleName FROM #temp AS t WHERE t.UserId = #temp.UserId FOR xml path(’’)
), 1, 1, ‘’
)
into #temp1
FROM #temp GROUP BY UserId
多行fieldname字段的内容串联起来,用逗号分隔
最新推荐文章于 2020-05-07 17:38:50 发布
SELECT UserId, RoleName = stuff(
(
SELECT ‘,’ + RoleName FROM #temp AS t WHERE t.UserId = #temp.UserId FOR xml path(’’)
), 1, 1, ‘’
)
into #temp1
FROM #temp GROUP BY UserId