index:当前页
size:每页显示多少条数据
rownumber:定义的别称
News:表名
select * from (select row_number()over(order by Newid)rownumber,* from News) a1 where a1.rownumber between(((" + index + "-1)*" + size + ")+1 )and (" + index + "*" + size + ")";
index:当前页
size:每页显示多少条数据
rownumber:定义的别称
News:表名
select * from (select row_number()over(order by Newid)rownumber,* from News) a1 where a1.rownumber between(((" + index + "-1)*" + size + ")+1 )and (" + index + "*" + size + ")";