SELECT [USERNAME], [USERACCOUNT]
, [ROLENAME] = stuff((
SELECT ',' + [ROLENAME]
FROM [TEST].[dbo].[T_Role]
WHERE [USERACCOUNT] = a.[USERACCOUNT]
FOR XML path('')
), 1, 1, '')
FROM [TEST].[dbo].[T_Role] a
GROUP BY [USERNAME], [USERACCOUNT]
sql server 一对多单行显示
最新推荐文章于 2023-11-15 09:12:34 发布