declare @a char(8),@b varchar(10),@c numeric(5,2)
declare xxx cursor
for select 学号,课程名,成绩
from score
open xxx
fetch xxx into @a,@b,@c
while @@fetch_status=0
begin
print @a+replicate(' ',3)
+@b+str(@c)+replicate(' ',3)
+(case
when @c>=90 then '优秀'
when @c>=70 then '良好'
when @c>=60 then '及格'
else '不及格'
end
)
fetch from xxx into @a,@b,@c
end
close xxx
deallocate xxx
显示出score表中每个成绩记录，并在每条记录最后给出优秀、良好、及格、不及格等相应等级。
