sql 获取字段值字符串

 (select stuff((select ',' +cast(PathId as varchar) from RoleInPath  where RoleId=o.RoleId for xml path('')),1,1,'')+','+ (select stuff((select ',' +cast(PathId as varchar) from UserInPath where UserId=o.ID for xml path('')),1,1,'')))
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/xiaonangua/p/10855067.html