不好意思
改进一下
create proc randAccess
@randomSeed int --初始化随即种子
@randomRage int --随机数取值范围
@interval int --定长
as
declare @randomNum int
select @randomNum=rand(@randomSeed)*@randomRage
declare pCur cursor for
select * from tbl_1
open pCur
fetch ABSOLUTE @randomNum FROM pCur
while @@fetch_status=0
begin
fetch RELATIVE @interval FROM pCur
end
DEALLOCATE pCur
create proc randAccess
@randomSeed int
@interval int
as
declare @randomNum int
select @randomNum=rand(@randomSeed)
declare pCur cursor for
select * from tbl_1
open pCur
fectch ABSOLUTE @randomNum FROM pCur
while @@fetch_status=0
begin
FETCH RELATIVE @interval FROM authors_cursor
end
DEALLOCATE pCur