15.5 .net聚合.sql

介绍了SQL的一些基本知识,对新手应该很用出的!

--使用用户定义聚合
SELECT     Users.UserID, Users.Name, dbo.GetArray(Roles.RoleName) AS '角色列表'
FROM         Roles INNER JOIN
                  UserRole ON Roles.RoleID = UserRole.RoleID INNER JOIN
                  Users ON UserRole.UserID = Users.UserID
GROUP BY Users.UserID,Users.Name