查詢四張表aspnet_Membership,aspnet_Users,Users,UserRoles。
declare @username nvarchar(100)
declare @userpwd nvarchar(100)
set @username='admin'
set @userpwd='password'
SELECT * FROM aspnet_Membership aM, aspnet_Users aU,Users U,UserRoles UR where aM.UserId=aU.UserId and
aU.UserName=U.Username and U.UserID=UR.UserID
and U.Username=@username and aM.password=@userpwd and UR.roleid=0
select * from (((aspnet_Membership INNER JOIN aspnet_users ON aspnet_Membership.UserId = aspnet_users.UserId)
INNER JOIN Users ON aspnet_users.username=Users.username)INNER JOIN UserRoles ON Users.userid=UserRoles.userid)
where Users.Username=@username and aspnet_Membership.password=@userpwd and UserRoles.roleid=0
使用上面的查詢語句可以查詢指定的username和password并且角色roleid=0的結果。
本文轉自xwdreamer部落格園部落格,原文連結:http://www.cnblogs.com/xwdreamer/archive/2010/03/15/2297159.html,如需轉載請自行聯系原作者