怎样使用触发器？

Question

CREATE TRIGGER adchange ON [dbo].[admint] 
FOR INSERT, UPDATE
AS
    delete s_zj from deleted where s_zj.dwid = inserted.dwid
    insert into s_zj select * from inserted
END
go
CREATE TRIGGER adchange ON [dbo].[admint] 
FOR delete
AS
    delete s_zj from deleted where s_zj.dwid = deleted.dwid
END

Answer 1

分别写三个：
CREATE TRIGGER t1 ON [dbo].[admint] 
FOR INSERT
AS
  insert into s_zj select * from inserted
go
CREATE TRIGGER t2 ON [dbo].[admint] 
FOR delete
AS
  delete s_zj where s_zj.仪器编号 = deleted.yqID
go
CREATE TRIGGER t3 ON [dbo].[admint] 
FOR update
AS
  delete s_zj where s_zj.仪器编号 = deleted.yqID
  insert into s_zj select * from inserted
go