ALTER??PROCEDURE?dbo.aspnet_UsersInRoles_GetUsersInRoles?--查詢某角色的用戶
????@ApplicationName??NVARCHAR(256),
????@RoleName?????????NVARCHAR(256)
AS
BEGIN
????DECLARE?@ApplicationId?UNIQUEIDENTIFIER
????SELECT??@ApplicationId?=?NULL
????SELECT??@ApplicationId?=?ApplicationId?FROM?aspnet_Applications?WHERE?LOWER(@ApplicationName)?=?LoweredApplicationName
????IF?(@ApplicationId?IS?NULL)
????????RETURN(1)
????/**//*返回@ApplicationId,不存在返回1*/
?????DECLARE?@RoleId?UNIQUEIDENTIFIER
?????SELECT??@RoleId?=?NULL

?????SELECT??@RoleId?=?RoleId
?????FROM????dbo.aspnet_Roles
?????WHERE???LOWER(@RoleName)?=?LoweredRoleName?AND?ApplicationId?=?@ApplicationId
?????/**//*查詢此用戶的角色ID*/??
??

?????IF?(@RoleId?IS?NULL)
?????????RETURN(1)

????SELECT?u.UserName
????FROM???dbo.aspnet_Users?u,?dbo.aspnet_UsersInRoles?ur
????WHERE??u.UserId?=?ur.UserId?AND?@RoleId?=?ur.RoleId?AND?u.ApplicationId?=?@ApplicationId
????ORDER?BY?u.UserName
????RETURN(0)
????/**//*查詢此角色的全部用戶*/
END

轉(zhuǎn)載于:https://www.cnblogs.com/ruanbl/archive/2006/09/01/492408.html

總結(jié)

以上是生活随笔為你收集整理的aspnet_UsersInRoles_GetUsersInRoles的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。