本文详细介绍了SQL Server 2012中新增的分页语法，包括创建表、插入数据及使用分页查询的示例。
--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;
扫一扫
72
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
