dbcc freeproccache

dbcc dropcleanbuffers

set statistics time on

set statistics io on

set statistics profile on;

with #pager as

(

select ID,Title,ROW_NUMBER() OVER(Order By ID) as rowid from Article_Detail

)

select ID,Title from #pager where rowid between (15 * (50-1)+1) and 15 * 50

set statistics profile off;

--语法

OFFSET { integer_constant | offset_row_count_expression } { ROW | ROWS }

FETCH { FIRST | NEXT } { integer_constant | fetch_row_count_expression } { ROW | ROWS } ONLY

--代码示例
dbcc freeproccache

dbcc dropcleanbuffers

set statistics time on

set statistics io on

set statistics profile on;

select ID,Title from Article_Detail order by id OFFSET (15 * (50-1)) ROW FETCH NEXT 15 rows only

set statistics profile off;