论坛 › SQL Server › 一个sql server递归查找的实例

fddd 发表于 2013-12-11 10:16:48

一个sql server递归查找的实例

with as (SELECT
      row_number() over (order by U.UserName) AS rowid,
      U.*,
      UP.PortalId,
      UP.Authorised,
      UP.RefreshRoles
       FROM dbo.UserPortals AS UP
         RIGHT OUTER JOIN dbo.UserRolesUR
         INNER JOIN dbo.Roles R ON UR.RoleID = R.RoleID
         RIGHT OUTER JOIN dbo.Users AS U ON UR.UserID = U.UserID
      ON UP.UserId = U.UserID
       WHERE ( UP.PortalId = @PortalID OR @PortalID IS Null )
      AND (UP.IsDeleted = 0 OR UP.IsDeleted Is NULL)
      AND (R.RoleId = @RoleId)
      AND (R.PortalId = @PortalID OR @PortalID IS Null )
      AND (U.IsSuperUser = @IsSuperUser)
)
select * from
   where rowid > @PageLowerBound and rowid < @PageUpperBound
   order by rowid

kinght2008 发表于 2013-12-16 23:46:51

退潮的爱像刀疤、伤过就给一个说法、

isp.上海 发表于 2013-12-23 03:43:47

花花世界丶原来不是曾经想的{那么简单}

star870126 发表于 2013-12-28 15:18:41

妈妈说要我好好珍惜你。我说我会用生命守护你

查看完整版本: 一个sql server递归查找的实例