Sql server分页查询
//这个方法只能适用于2005版本及以上
select top 10* from (select row_number() over(order by mdid asc) as rownumber ,*from MeterDataS) MeterDataS where rownumber>0 //查询0-10行的数据
select top 10* from (select row_number() over(order by mdid asc) as rownumber ,*from MeterDataS) MeterDataS where rownumber>10 //10行一页,查询第二页