declare @a char(8),@b varchar(10)
declare @s char(8),@r varchar(10)
set @s='20030001'
set @r='数学'
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)
begin
delete from score
where current of xxx
break
end
fetch from xxx into @a,@b
end
close xxx
deallocate xxx
从score表中删除学号为@a的值、课程名为@b的值的学生记录