sqlserver2000分页查询[根据网上搜索到得sql修改]
select top 页大小 * from testtable where (id > (select case when count(0) < 页大小 then 0 else max(id) end from (select top 页大小*(页数-1) id from 表 order by id) as t)) order by id
sqlserver2000分页查询[根据网上搜索到得sql修改]
select top 页大小 * from testtable where (id > (select case when count(0) < 页大小 then 0 else max(id) end from (select top 页大小*(页数-1) id from 表 order by id) as t)) order by id