SQL触发器作业3页.doc

1.为SC创建一个触发器,当插入或者修改一个记录时候,确保此记录的成绩在0-100之间.Create trigger Score_sc_tri On SC For Insert,update As declare score_read tinyint Select score_read=score from inserted If score_read=0 and score_read=100 begin Print 操作完成! Return End Print 成绩超出之间！请重新输入. Rollback TransactionINSERT INTO SC VALUES(S1,C5,190) GO INSERT INTO SC VALUES(S1,C5