declare @pageindex int ;
declare @pagesize int;
set @pageindex=1;
set @pagesize=3;
select * from (select ROW_NUMBER() over(order by Id) as rownumber,* from T_News) A where rownumber >(@pageindex-1)*@pagesize and rownumber <=@pageindex*@pagesize
declare @pagesize int;
set @pageindex=1;
set @pagesize=3;
select * from (select ROW_NUMBER() over(order by Id) as rownumber,* from T_News) A where rownumber >(@pageindex-1)*@pagesize and rownumber <=@pageindex*@pagesize