【急!在线等】数据库成绩系统触发器建立问题
皮皮虾APP
2024-05-13 22:26:41
最佳回答
create trigger tri_setcridit on sc after upate,delete as
declare
@sno char(10),
@cno char(6),
@grade varchar(3),
@gradebu varchar(6),
@credit numeric(2,1)
if update(grate) or update(grade)
begin
select @sno=sno,@cno=cno,@grade=grade,@gradebu=gradebu
from inserted
if (grade>='60') or gradebu='及格'
select @credit=credit from course where cno=@cno
else
select @credit=0
update sc set credit=@credit where sno=@sno and cno=@cno
emd 20210311