使用存储过程分页
create proc fenye3
@pagesize int,
@pageindex int
as
select * from (select ROW_NUMBER() over (order by articleid ) as number , * from ArticleInfo )t
where number >(@pageindex-1)* @pagesize and number <= @pageindex* @pagesize
//执行存储过程 每页三条数据,第一页
exec fenye3 3,1