create trigger 触发器名字 on 要绑定的表
{for|instead of|after} {update|delete|insert}
as
select * from deleted --可以获取到更改前的数据
select * from inserted --可以获取到更改后的数据
create trigger apan_tr
on 选课
after insert ,update
as
declare @scord float,@ori_scord float,@id char(20),@name char(20)
select @scord=成绩 ,@id=学号 from inserted
select @ori_scord=入学成绩,@name=姓名 from 学生 where 学号=@id
if @scord > 85
begin
update 学生 set 有否奖学金=0
select @name+'同学的平均成绩为:'+case(@scord as char(10))+'分,可得到奖学金!'
end
if @scord < 85 and @ori_scord >600
begin
update 学生 set 有否奖学金=1
select @name+'同学的入学成绩为:'+ case(@ori _scord as varchar(10))+'分,可得到奖学金!'
end
if @scord < 85 and @ori_scord <600
begin
update 学生 set 有否奖学金=0
select @name+'同学的平均成绩为:'+ case(@scord as varchar(10))+'分,入学成绩为: '+ case(@ori _scord as varchar(10))+'无法得到奖学金!'
end
return
评论区