----定义
declare test_cursor1 cursor for
select * from testgo
----打开
open test_cursor1
----执行
fetch next from test_cursor1
----关闭
close test_cursor1
----释放游标
deallocate test_cursor1
1.http://www.cnblogs.com/moss_tan_jun/archive/2011/11/26/2263988.html
2.http://www.cnblogs.com/quietwalk/archive/2011/10/17/2215428.html
----游标的用法执行顺序
1、定义游标、打开游标
declare test1_cursor cursor for
select className from class
open test1_cursor
----执行游标(获取数据并打印出来)
declare @class_name varchar(30)
declare @Allclassname varchar(max)
fetch test1_cursor into @class_name //把当前行className的数据付给变量@class_name
set @Allclassname=@class_name
while(@@fetch_status=0)
begin
fetch test1_cursor into @class_name
set @Allclassname=@Allclassname+','+@class_name
end
--print @Allclassname ------打印
select @Allclassname as allname
close test1_cursor
deallocate test1_cursor
---@@fetch_status的状态含义