SQL 2012 分页取数据

create table T1( ID int identity(1,1), data int )

select * from t1
select data from t1 order by data offset 10001 row fetch next 49 rows only

create clustered index t1c on t1(id)


declare @i int
set @i=0
while (@i<10000)
begin
insert into t1(data) values(  floor(rand(abs(checksum(newid())))*1000 ))
set @i=@i+1
end

truncate table t1