请教触发器的写法
create trigger tgr_student_log
on dbo.T_student
after insert,update,delete
as
if ((exists (select 1 from inserted)) and (exists (select 1 from deleted)))
begin
insert into log(action) values('updated');
end
else if(exists(select 1 from inserted)and not exists(select 1 from deleted))
begin
insert into log(action) values('inserted');
end
else if (not exists(select 1 from inserted) and exists(select 1 from deleted))
begin
insert into log(action) values('deleted');
end
go
这是我建的一个简单的记录表操作的触发器,我想记录下所插入、修改或删除的内容和操作者该怎么写?
比如,我删除了T_student表中一个学生的信息,我想通过触发器记录下来被删除的这个学生的名字或者学号,以及是谁删除的?
请高手指教谢谢!