create trigger trigger_name on tableName for insert,update,delete as --some code goes here. go
建議 刪除 一個,新增和修改可以合并一個.要考慮到會用Deleted和 inserted 表.
CREATE TRIGGER tri_tb ON tb FOR insert,update,delete AS if not exists(select 1 from deleted)--insert begin ……; end else if not exists(select 1 from inserted)--delete begin ……; end else --update begin ……; end
for insert,update,delete
as
--some code goes here.
go
ON tb
FOR insert,update,delete
AS
if not exists(select 1 from deleted)--insert
begin
……;
end
else if not exists(select 1 from inserted)--delete
begin
……;
end
else --update
begin
……;
end