摘要： 1）关于分页语句1 not in select top pageSize * from table where tid not in (select top (pageIndex-1)*pagesize tid from table) ; --------------或者 select * from ( select *,Row_Number() over(order by id) RowNumber from books ) t where t.RowNumber>=2 and t.RowNumber<=7;2 使用存储过程 create Procedure GetPageDat 阅读全文