SQLserver分页语句

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 + ")";