第九章存储过程与触发器解析.pptVIP

@MINCHENGJI tinyint OUTPUT AS SELECT @AVGCHENGJI=AVG(成绩),@MAXCHENGJI=MAX(成绩),@MINCHENGJI=MIN(成绩) FROM 课程注册 WHERE 课程号in(SELECT 课程号FROM 课程WHERE 课程名=@KECHENGMING) GO USE student --声明四个变量，用于保存输入和输出参数 DECLARE @KECHENGMING varchar(20) DECLARE @AVGCHENGJI1 tinyint DECLARE @MAXCHENGJI1 tinyint DECLARE @MINCHENGJI1 tinyint --为输出参数赋值 SELECT @KECHENGMING=计算机基础 --执行存储过程 EXEC 单科成绩分析@KECHENGMING, @AVGCHENGJI1 OUTPUT, @MAXCHENGJI1 OUTPUT, @MINCHENGJI1 OUTPUT --显示结果 SELECT @KECHENGMING AS 课程名,@AVGCHENGJI1 AS 平均成绩,@MAXCHENGJI1 AS最高成绩,@MINCHENGJI1 AS 最低成绩 GO 9.2 触发器 9.2.1 触发器的概念 触发器是一