也可以这样写﹐速度可能会更快:
create proc sp_GetPermissions
@userid int,@fid int
as
Select p.*,c.DESCRIPTION,a.USERNAME
from USERS a,USER_ROLES b,ROLE c,ROLE_PERMISSION d,PERMISSION p
where a.USERID=b.USERID and b.ROLEID=c.ROLEID
and b.ROLEID=d.ROLEID and d.P_ID=p.P_ID
create proc sp_GetPermissions
@userid int,@fid int
as
Select p.*,c.DESCRIPTION,e.username
from permission a
join role_permission b on a.p_id = b.p_id
join role c on b.roleid = c.roleid
join user_roles d on c.roleid = b.roleid
join users e on d.userid = e.userid
where e.userid = @userid
and a.f_id = @fid