--声明游标 declare cursor1 cursor for select stu_name,stu_sex from stu --打开游标 open cursor1 --取游标 fetch next from cursor1 into @a,@b --释放游标 close cursor1 deallocate cursor1 --游标状态（成功） @@fetch_status=0 declare @name varchar(50) declare @age varchar(50) declare cursor1 cursor for select stu_name,stu_sex from stu --声明游标 open cursor1 --打开游标 fetch next from cursor1 into @name,@age --取游标 print @name+@age --打印数据 close cursor1 --释放游标 deallocate cursor1
本文出自 “程序猿的家--Hunter” 博客，请务必保留此出处http://962410314.blog.51cto.com/7563109/1572143
原文：http://962410314.blog.51cto.com/7563109/1572143