存储过程：
create procedure ticket
@pagesize int,@pageindex int
as
select * from
(
select row_number() over(order by markno desc) as 'rowno',*
from ticket
) as tick
where rowno>@pagesize*(@pageindex-1) and rowno<@pagesize*@pageindex+1
调用：
execute ticket @pagesize=4,@pageindex=1
存储过程的分页处理