第一種是最傳統(tǒng)的寫(xiě)法，用存儲(chǔ)過(guò)程中的變量作為分頁(yè)的乘數(shù)
復(fù)制代碼 代碼如下:
[c-sharp] view plaincopyprint?create proc p_paged1
@pageSize int,@currentPage int
as
select top (@pageSize) * from student
where id not in
(select top (@pageSize*(@currentPage-1)) id from student)
go
exec p_paged1 2,3
create proc p_paged1
@pageSize int,@currentPage int
as
select top (@pageSize) * from student
where id not in
(select top (@pageSize*(@currentPage-1)) id from student)
go
exec p_paged1 2,3
--SQL Server2005以后的分頁(yè)語(yǔ)句
復(fù)制代碼 代碼如下:
[c-sharp] view plaincopyprint?create proc p_paged2
@pageStart int, @pageEnd int
as
select * from
(select *,row_number() over(order by id desc) as rnum
from student) t
where t.rnum between @pageStart and @pageEnd
go
exec p_paged2 5,10
您可能感興趣的文章:- 高效的SQLSERVER分頁(yè)查詢(xún)(推薦)
- 真正高效的SQLSERVER分頁(yè)查詢(xún)(多種方案)
- 分頁(yè) SQLServer存儲(chǔ)過(guò)程
- sqlserver 通用分頁(yè)存儲(chǔ)過(guò)程
- sqlserver 三種分頁(yè)方式性能比較[圖文]
- 基于sqlserver的四種分頁(yè)方式總結(jié)
- sqlserver分頁(yè)查詢(xún)處理方法小結(jié)
- sqlserver 存儲(chǔ)過(guò)程分頁(yè)代碼
- SQL server分頁(yè)的4種方法示例（很全面）
