--SQL SERVER2012新增加的分页语法:
create table paging(
id int identity primary key,
somecol varchar(50)
)
go
insert into paging(somecol)
select name from master.sys.columns;
go
select ID,somecol from paging
order by id asc
offset 100 rows fetch next 21 rows only;
create table paging(
id int identity primary key,
somecol varchar(50)
)
go
insert into paging(somecol)
select name from master.sys.columns;
go
select ID,somecol from paging
order by id asc
offset 100 rows fetch next 21 rows only;