declare @a char(8),@b varchar(10),@c numeric(5,2)
declare @s char(8),@r varchar(10)
set @s='20030001'
set @r='数学'
set @c=84
declare xxx cursor
for select 学号,课程名 from score
open xxx
fetch xxx into @a,@b
while @@fetch_status=0
begin
if(@a=@s and @b=@r)
update score
set 成绩=@c
where current of xxx
fetch from xxx into @a,@b
end
close xxx
deallocate xxx
修改score表中学号为@a的值、课程名为@b的值的学生的成绩为@c的值。
