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

--not in 實現分頁查詢
declare @pageSize int set @pageSize= 10;--行數
declare @pageNo int set @pageNo = 1000;--頁數
select top(10) * from Info
where id not in (
?select top(@pageSize*(@pageNo-1)) id from Info
)?

-- 使用大于號 > 實現分頁查詢
declare @pageSize int set @pageSize= 10;?--行數
declare @pageNo int set @pageNo = 1000;??--頁數
select top(@pageSize) * from Info where id >
(select max(id) from???????????--取前十條數據的最大值
(select top(@pageSize*(@pageNo-1)) id from Info) as empInfo)?? --查詢前十條數據

--使用 row_num between 實現分頁查詢
select * from
(select ROW_NUMBER() over(order by id) as no,* from Info) as emp
where emp.no between 100 and 110

sql分頁查詢