sql创建一个触发器 当输入某个同学选课成绩时,如果他是女生,其成绩自动加5分

Question

如题所述

Answer 1

create trigger tgr_classes_insert
on classes
for insert --插入触发
as
--定义变量
declare @id int, @name varchar(20), @temp int;--成绩
--是女的更新数据，男的就算了
if（exists(select @id = id, @name = name，@temp =temp from inserted where 性别=女)）;
begin
set @temp = @temp +5;
update student set temp = @temp where id=@id and name=@name;
end
go