SqlServer中使用游标实现分页效果

最新推荐文章于 2024-08-21 11:29:11 发布

幸福的小木鱼

最新推荐文章于 2024-08-21 11:29:11 发布

阅读量1.3k

点赞数

分类专栏：数据库学习(Oracle,SqlServer,MySql) 文章标签： sqlserver scroll

本文链接：https://blog.csdn.net/lin_lujian/article/details/6914230

版权

数据库学习(Oracle,SqlServer,MySql) 专栏收录该内容

23 篇文章 1 订阅

订阅专栏

create proc pageproc
@pageIndex int,
@pageSize int
as
begin
declare cur cursor scroll for select stuName,stuno from stuInfo
declare @count int
declare @name varchar(20)
declare @no varchar(20)
set @count=(@pageIndex-1)*@pageSize+1
open cur
fetch absolute @count from cur into @name,@no
while @count<=@pageSize*@pageIndex and @@FETCH_STATUS=0
begin
	print @name+'   '+@no
	set @count=@count+1
	fetch absolute @count from cur into @name,@no
end
close cur
deallocate cur
end
go