SQL 语句行数据拆成多行及多行数据合并成一行的方法



SELECT UserId,
 

   STUFF((SELECT ',' + Cast(A.RoleName as varchar)

        FROM View_User_Role A Where A.UserId=B.UserId FOR XML PATH('')),1,1,'') As RoleName

  From View_User_Role B

  Group By UserId