34,576
社区成员
发帖
与我相关
我的任务
分享
sc表有ID和getcredit列
---ID就主健
create trigger ins_credit on sc
instead of update,insert
if not exists(select 1 from deleted)--操作为新增
begin
insert sc
select
ID,case when getcredit>80 then (select credit from course where cno=i.cno) else 0 end
from
inserted i
end
else --其它为更新
begin
update j
set grade=i.grade,getcredit=case when i.getcredit>80 then (select credit from course where cno=i.cno) else 0 end
from
inserted i join cs j on i.ID=j.ID
end