declare @s_no char(9), @s_name char(10)
declare @s_sex char(2), @s_age smallint, @s_dept char(20)
fetch next from cs_stu_cursor
into @s_no, @s_name, @s_sex, @s_age, @s_dept
while @@fetch_status = 0
begin
print @s_no
print @s_name
print @s_sex
print @s_age
print @s_dept
fetch next from cs_stu_cursor
into @s_no, @s_name, @s_sex, @s_age, @s_dept
end
游标的关闭与释放
用游标修改和删除基本表数据
用游标修改和删除基本表数据示例
declare cur_sc cursor for
select * from sc
for update of grade
open cur_sc
declare @s_no char(9), @c_no char(4), @grade smallint
fetch next from cur_sc into @s_no, @c_no, @grade
while @@fetch_stat