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

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

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!