go
declare student_cur cursor
for select * from student
go
declare @sid int
declare @sname varchar(20)
declare @ssex char(1)
declare @sage int
declare @classid int
open student_cur
fetch next from student_cur into @sid,@sname,@ssex,@sage,@classid
while @@fetch_status=0
begin
print @sname
fetch next from student_cur into @sid,@sname,@ssex,@sage,@classid
end
close student_cur
deallocate student_cur
/*******************************
说明：游标的操作(update)
*******************************/
use student_15
go
select * from student
go
declare student_cur cursor
scroll --游标的移动位置
for select * from student
for update of sname,sage
go
declare @sid int
declare @sname varchar(20)
declare @ssex char(1)
declare @sage int
declare @classid int
open student_cur
fetch first from student_cur into @sid,@sname,@ssex,@sage,@classid
/*更新游标数据*/
update student set sage=19,sname='11' where current of student_cur
while @@fetch_status =0 begin
fetch next from student_cur into @sid,@sname,@ssex,@sage,@classid
if @sid=1003 begin
update student set sage=19,sname='11' where current of student_cur
end
end
close student_cur
deallocate student_cur
/*************游标操作删除***************/
use student_15
go
declare student_cur cursor
scroll
for select * from student
for update of sid
go
declare @sid int
declare @sname varchar(20)
declare @ssex char(1)
declare @sage int
declare @classid int
open student_cur
fetch first from student_cur into @sid,@sname,@ssex,@sage,@classid
while @@fetch_status=0
begin
fetch next from student_cur into @sid,@sname,@ssex,@sage,@classid
if @sid=1003
begin
delete student where current of student_cur
end
end
close student_cur
deallocate student_cur
