摘要： for xml方式select * from view_1select distinct Id,Name, rolekey=( select roleName as [data()] from view_1 where view_1.id =v.id for xml path (''))from view_1 v原始表0000-0000-0000-0001 其他类型? NULL null 1 权限... 阅读全文