③定义一个AFTER的行级触发器Print_f,当往成绩表(SC)中插入的成绩小于60就打印不及格
答案说明:本题目答案来自网络整理或转载,最终答案请以官网为准。
答 案:③CREATE TRIGGER Print_f AFTER INSERT ON Student FOR EACH ROW AS BEGIN IF(new.Grade60) THEN PRINT'不及格' END IF END;
③CREATE TRIGGER Print_f AFTER INSERT ON Student FOR EACH ROW AS BEGIN IF(new.Grade60) THEN PRINT'不及格' END IF END; 解析:创建视图用CTREATE VIEW,而创建触发器是用CREATE TRIGGER,触发器分为行级触发器和语句级触发器,FOR EACH ROW是行级触发器。