插入后，一次触发即可更新

本文介绍了插入后，一次触发即可更新的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

嗨 我编写了一个触发器，当您在特定表中更新或插入任何记录时会触发该触发器. 现在，我想在将记录插入表中时在触发器中执行一个代码块. 并且我想在更新表中的任何记录时在触发器中执行另一个代码块. 如何在触发器中放置条件. 问候，

Hi I have written a trigger which gets fired when you update or insert any record in a particular table. Now, I want to execute one block of code in the trigger when i insert a record into the table. and i want to execute another block of code in the trigger when i update any record in the table. How can i put a condition in the trigger. Regards,

推荐答案

您不需要放置条件元素. 创建两个触发器-一个用于插入，另一个用于更新. 只需根据您的要求选择FOR(INSERT | UPDATE) [ ^ ]. You dont need to put conditional elements. Create two triggers - one for insert and another for update. Just choose the FOR (INSERT | UPDATE) based on your requirement[^].

试试这个示例代码 Hi, Try this sample code CREATE TRIGGER dbo.TableName_IUD ON dbo.TableName AFTER INSERT, UPDATE, DELETE AS BEGIN SET NOCOUNT ON; DECLARE @action CHAR(8) IF COLUMNS_UPDATED() <> 0 -- delete or update? BEGIN IF EXISTS (SELECT * FROM deleted) -- updated cols + old rows means action=update SET @action = 'UPDATE' ELSE SET @action = 'INSERT' -- updated columns and nothing deleted --means action=insert END ELSE -- delete BEGIN SET @action = 'DELETE' END END

谢谢

Thank you