举例:declare cursor_insert cursor for select c# from cs
declare
@i int
open cursor_insert
fetch cursor_insert into @i
while @@fetch_status=0
begin
print @i
fetch cursor_insert into @i
end
close cursor_insert
deallocate cursor_insert
declare
@i int
open cursor_insert
fetch cursor_insert into @i
while @@fetch_status=0
begin
print @i
fetch cursor_insert into @i
end
close cursor_insert
deallocate cursor_insert
declare
@i int
open cursor_insert
fetch cursor_insert into @i
while @@fetch_status=0
begin
print @i
fetch cursor_insert into @i
end
close cursor_insert
deallocate cursor_insert
declare 游标名 cursor for select 字段名 from 表名 --定义游标
declare @字段值变量 int --定义变量,用来保存从游标中取得的值
open 游标名 --打开游标
fetch 游标名 into 字段值变量
while @@fetch_status=0 --循环读取值
begin
print @字段值变量 --显示取得的值
fetch 游标名 into 字段值变量
end
close 游标名 --关闭游标
deallocate 游标名 --删除游标