其实这三个例子都不是我原创的,随便网上找的,现在粘一块算是提供个能用的格式吧。
1.Insert
CREATE TRIGGER tri_Insert羊
ON 羊
AFTER INSERT
AS
BEGIN
declare @sheepno sysname
select @sheepno=LTRIM(羊编号) from inserted;
insert into 记录(羊编号) values(@sheepno);
SET NOCOUNT ON;
END
2.Delete
使用级联删除
假如两个表通过id关联
create trigger tri_delete
on table1
after delete
as
begin
delete
from table2
where table2.id in(
select id from deleted)
end
3.Update
Create TRIGGER [dbo].[tri_Update羊子]
ON [dbo].[羊]
AFTER UPDATE
AS
if update(羊编号)
BEGIN
update 记录
set 羊编号=i.羊编号
from 记录 jl,Deleted d,inserted i
where jl.羊编号=d.羊编号
end