7、在使用参数管理存储过程触发器时,请参考以下示例:使用 school 数据库 go --创建视图,统计每个班级每门课程的平均成绩 if exists(select name from sysobjects where name='claview_avg') drop view claview_avg go create view claview_avg as (select class, score.cno, avg(degree) as class_avg from student, score where student.sno=score.sno group by class, cno) Go --未完,详细内容请参阅下一页