create proc usp_mystudent _GetDataByPageIndex
@pagesize int=10,--如果不定义自动显示10行
@pageIndex int
as
begin
select *from
(select *,ROW_NUMBER() over(order by Fid) as rowIndex from MyStudent)as tb1
where tb1.rowIndex between(@pagesize*(@pageIndex-1)+1)and@pageIndex*@pagesize
end
exec usp_mystudent _GetDataByPageIndex 5,3