我想将这两个触发器组合成单个触发器。如何做到这一点 [英] I want to combine these two triggers in to single trigger .how to do that

问题描述

CREATE TRIGGER [dbo].[triggername] ON [dbo].[tablename] AFTER INSERT
AS

BEGIN

INSERT INTO  tablename_history
SELECT * FROM INSERTED


PRINT 'AFTER INSERT Trigger fired.'
END

< br $> b $ b

CREATE TRIGGER [dbo].[triggername] ON [dbo].[tablename] FOR UPDATE
AS

BEGIN

INSERT INTO tablename_history

SELECT * FROM DELETED

PRINT 'FOR UPDATE Trigger fired.'
END

推荐答案

您可以在由a分隔的同一个create语句中添加INSERT和UPDATE逗号。如下所示



有关创建TRIGGER的更多信息，请参阅：http：//msdn.microsoft.com/en-us/library/ms189799.aspx

You can add INSERT and UPDATE in the same create statement separated by a comma. Something like below

For more info on Create TRIGGER refer : http://msdn.microsoft.com/en-us/library/ms189799.aspx

CREATE TRIGGER [dbo].[triggername] ON [dbo].[tablename] AFTER INSERT, UPDATE
AS

BEGIN

IF EXISTS(SELECT * FROM DELETED)
  BEGIN
    SELECT * FROM DELETED;
  END

ELSE 

  BEGIN
    INSERT INTO  tablename_history;
    SELECT * FROM INSERTED;
  END 

 

PRINT 'AFTER INSERT/UPDATE Trigger fired.';
END

这篇关于我想将这两个触发器组合成单个触发器。如何做到这一点的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！