查询的当前 数据库下所有用户表 select * from sys.tables
1. top not in
numberSize 数据条数/页
numberPsge 页数
select top numberSize * from 表 where 主键 not in (select top numberSize*(numberPage-1) 主键 from biao order by 主键) order by 主键
2 offset fetch next (2012以上的版本支持)
select * from 表 order by 主键 offset numberSize * (numberPage -1 ) rows fetch next numberSize rows only
3 row_number()
(1)
select * from (
select *,row_number() over(order by 主键) as RowID from 表
)
where RowID between ((numberPage-1)*numberSize)+1 and numberPage*numberSize
(2)
select top numberSize * from (
select *,row_number() over(order by 主键) as RowID from 表
)
where RowID >((numberPage-1)*numberSize)