insert into Info select 'admin36' from Info; --FK插入法
select COUNT(*) from Info;

--not in 實(shí)現(xiàn)分頁(yè)查詢(xún)
declare @pageSize int set @pageSize= 10;--行數(shù)
declare @pageNo int set @pageNo = 1000;--頁(yè)數(shù)
select top(10) * from Info
where id not in (
?select top(@pageSize*(@pageNo-1)) id from Info
)?

-- 使用大于號(hào) > 實(shí)現(xiàn)分頁(yè)查詢(xún)
declare @pageSize int set @pageSize= 10;?--行數(shù)
declare @pageNo int set @pageNo = 1000;??--頁(yè)數(shù)
select top(@pageSize) * from Info where id >
(select max(id) from???????????--取前十條數(shù)據(jù)的最大值
(select top(@pageSize*(@pageNo-1)) id from Info) as empInfo)?? --查詢(xún)前十條數(shù)據(jù)

--使用 row_num between 實(shí)現(xiàn)分頁(yè)查詢(xún)
select * from
(select ROW_NUMBER() over(order by id) as no,* from Info) as emp
where emp.no between 100 and 110

sql分頁(yè)查詢(xún)