一个简单的SQl存储过程分页

create proc Pro_name
@pagesize int,
@pageindex int
as
select * from(select ROW_NUMBER() over( order by ARTICLEID)number ,* from ArticleInfo)t
where t.number>(@pageindex-1)*@pagesize and t.number<=@pageindex*@pagesize
go