SqlServer 分頁查詢1.not in方法select top 10 from books where id not in(select top 30 id from books)2.row_number()函數select * from (select *,row_number() over (order by id) numfrom books) a where num between 31 and 403.存儲過程分頁create PRoc proc_AdminPages@pageIndex int,--當前頁碼@pageSize int--每頁數量asdeclare @begin int,@end int--定義局部變量set @begin=@pageSize*(@pageIndex-1)+1--賦值set @end=@pageSize*@pageIndexselect * from (select ROW_NUMBER() over(order by id) as RowIndex,* from Admin) awhere RowIndex between @begin and @end--執行exec proc_AdminPages 2,1
