游标练习

select * from person

declare PersonCur cursor for select name from person

open personcur

declare @c nvarchar(50)
fetch first from personcur into @c
print @c

close personcur

deallocate personcur

declare PersonCur cursor scroll for select name from person

open personcur

declare @c nvarchar(50)
 fetch first from personcur into @c
 print @c
 
 declare PersonCur2 cursor scroll for select * from person
 
 open personcur2
 
 declare @id int
 declare @name nvarchar(50)
 declare @name2 nvarchar(50)
 fetch relative -1  from personcur2 into @id,@name,@name2
 print @id
 print @name
 print @name2
 
 declare @id int
 declare @name nvarchar(50)
 declare @name2 nvarchar(50)
 while @@FETCH_STATUS=0
 begin
 print @id
 print @name
 print @name2
 fetch next from personcur2 into @id,@name,@name2
 end
 
 select @@FETCH_STATUS
 
 close personcur2
 deallocate personcur2

转载于:https://www.cnblogs.com/honghong75042/p/3305300.html