我想将这两个触发器组合成单个触发器。如何做到这一点 [英] 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屋!
查看全文