²»ÊÇÆ´SQLÓï¾äµÄÒ³Ãæ´æ´¢¹ý³Ì

ALTER PROCEDURE [dbo].[GetUsersList]
@BigClassID int=0,--´óÀà±ðID
@SmallClassID int=0 ,--СÀà±ðID
@pageindex int=1,
@pagesize int=3,
@ret int output --¹²¼¸Ìõ
AS
set rowcount @pagesize
if @SmallClassID>0
begin
select * from(
select id,BigClassName,SmallClassName,UserName,Corporation,rank() over(order by id desc) as rownumber from Users where BigClassID=@BigClassID and SmallClassID=@SmallClassID
)t where t.rownumber>(@pageindex-1)*@pagesize;
set @ret=(select count(id) from Users where BigClassID=@BigClassID and SmallClassID=@SmallClassID);
end
else
begin
select * from(
select id,BigClassName,SmallClassName,UserName,Corporation,rank() over(order by id desc) as rownumber from Users
)t where t.rownumber>(@pageindex-1)*@pagesize;
set @ret=(select count(id) from Users) ;
end