blocks|key|1584171|text|触发器有特殊的INSERTED和DELETED表来跟踪“之前”和“之后”的数据。所以你可以使用像IF+EXISTS+(SELECT+*+FROM+DELETED)这样的东西来检测更新。在update时，您只在DELETED中有行，但在INSERTED中总是有行。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1584172|在CREATE+TRIGGER中查找"inserted“。|1584173|编辑，2011年11月23日|1584174|注释之后，此答案仅适用于INSERTED和UPDATED触发器。|1584175|显然，DELETE触发器不能像我上面所说的那样具有“INSERTED中的所有行”|1584176|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql^0|7|8|G|7|1C|X|2W|7|39|8|0|1|E|0|0|0|C|8|L|7|0|Q|8|0^^$0|@$1|2|3|4|5|6|7|V|8|@$9|W|A|X|B|C]|$9|Y|A|Z|B|C]|$9|10|A|11|B|C]|$9|12|A|13|B|C]|$9|14|A|15|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|16|8|@]|D|@$9|17|A|18|1|19]]|E|$]]|$1|H|3|I|5|6|7|1A|8|@]|D|@]|E|$]]|$1|J|3|K|5|6|7|1B|8|@$9|1C|A|1D|B|C]|$9|1E|A|1F|B|C]]|D|@]|E|$]]|$1|L|3|M|5|6|7|1G|8|@$9|1H|A|1I|B|C]]|D|@]|E|$]]|$1|N|3|-4|5|6|7|1J|8|@]|D|@]|E|$]]]|O|$P|$5|Q|R|S|E|$T|U]]]]

Triggers have special <code>INSERTED</code> and <code>DELETED</code> tables to track &quot;before&quot; and &quot;after&quot; data. So you can use something like <code>IF EXISTS (SELECT * FROM DELETED)</code> to detect an update. You only have rows in <code>DELETED</code> on update, but there are always rows in <code>INSERTED</code>.
Look for &quot;inserted&quot; in <a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql" rel="noreferrer">CREATE TRIGGER</a>.
Edit, 23 Nov 2011
After comment, this answer is only for <code>INSERTED</code> and <code>UPDATED</code> triggers. 
Obviously, DELETE triggers can not have &quot;always rows in <code>INSERTED</code>&quot; as I said above

blocks|key|1369080|text|经过多次搜索，我找不到一个SQL+Server触发器可以处理所有(3)个触发器操作INSERT、UPDATE和DELETE的确切示例。我终于找到了一行文字，它谈到了这样一个事实，即当发生删除或更新时，通用的已删除表将包含这两个操作的记录。基于这些信息，我创建了一个小的Action例程，用于确定触发器被激活的原因。当INSERT+vs.触发器上既有公共配置又有特定操作时，有时需要这种类型的接口。在这些情况下，为UPDATE和INSERT创建单独的触发器将成为维护问题。(例如，对于必要的公共数据算法修复，两个触发器都正确更新了吗？)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1369081|为此，我想给出下面的多触发器事件代码片段，用于在Microsoft+SQL+Server的一个触发器中处理插入、更新和删除。|1369082|CREATE+TRIGGER+[dbo].[INSUPDDEL_MyDataTable]
ON+[dbo].[MyDataTable]+FOR+INSERT,+UPDATE,+DELETE
AS+

--+SET+NOCOUNT+ON+added+to+prevent+extra+result+sets+from
--+interfering+with+caller+queries+SELECT+statements.
--+If+an+update/insert/delete+occurs+on+the+main+table,+the+number+of+records+affected
--+should+only+be+based+on+that+table+and+not+what+records+the+triggers+may/may+not
--+select.
SET+NOCOUNT+ON;

--
--+Variables+Needed+for+this+Trigger
--+
DECLARE+@PACKLIST_ID+varchar(15)
DECLARE+@LINE_NO+smallint
DECLARE+@SHIPPED_QTY+decimal(14,4)
DECLARE+@CUST_ORDER_ID+varchar(15)
--
--+Determine+if+this+is+an+INSERT,UPDATE,+or+DELETE+Action
--+
DECLARE+@Action+as+char(1)
DECLARE+@Count+as+int
SET+@Action+=+'I'+--+Set+Action+to+'I'nsert+by+default.
SELECT+@Count+=+COUNT(*)+FROM+DELETED
if+@Count+>+0
++++BEGIN
++++++++SET+@Action+=+'D'+--+Set+Action+to+'D'eleted.
++++++++SELECT+@Count+=+COUNT(*)+FROM+INSERTED
++++++++IF+@Count+>+0
++++++++++++SET+@Action+=+'U'+--+Set+Action+to+'U'pdated.
++++END

if+@Action+=+'D'
++++--+This+is+a+DELETE+Record+Action
++++--
++++BEGIN
++++++++SELECT+@PACKLIST_ID+=[PACKLIST_ID]
++++++++++++++++++++,@LINE_NO+=+[LINE_NO]
++++++++FROM+DELETED

++++++++DELETE+[dbo].[MyDataTable]
++++++++WHERE+[PACKLIST_ID]=@PACKLIST_ID+AND+[LINE_NO]=@LINE_NO
++++END
+Else
++++BEGIN
++++++++++++--
++++++++++++--+Table+INSERTED+is+common+to+both+the+INSERT,+UPDATE+trigger
++++++++++++--
++++++++++++SELECT+@PACKLIST_ID+=[PACKLIST_ID]
++++++++++++++++,@LINE_NO+=+[LINE_NO]
++++++++++++++++,@SHIPPED_QTY+=[SHIPPED_QTY]
++++++++++++++++,@CUST_ORDER_ID+=+[CUST_ORDER_ID]
++++++++++++FROM+INSERTED+

+++++++++if+@Action+=+'I'
++++++++++++--+This+is+an+Insert+Record+Action
++++++++++++--
++++++++++++BEGIN
++++++++++++++++INSERT+INTO+[MyChildTable]
++++++++++++++++++++(([PACKLIST_ID]
++++++++++++++++++++,[LINE_NO]
++++++++++++++++++++,[STATUS]
++++++++++++++++VALUES
++++++++++++++++++++(@PACKLIST_ID
++++++++++++++++++++,@LINE_NO
++++++++++++++++++++,'New+Record'
++++++++++++++++++++)
++++++++++++END
++++++++else
++++++++++++--+This+is+an+Update+Record+Action
++++++++++++--
++++++++++++BEGIN
++++++++++++++++UPDATE+[MyChildTable]
++++++++++++++++++++SET+[PACKLIST_ID]+=+@PACKLIST_ID
++++++++++++++++++++++++++,[LINE_NO]+=+@LINE_NO
++++++++++++++++++++++++++,[STATUS]='Update+Record'
++++++++++++++++WHERE+[PACKLIST_ID]=@PACKLIST_ID+AND+[LINE_NO]=@LINE_NO
++++++++++++END
++++END+++|code-block|syntax|javascript|1369083|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

After a lot of searching I could not find an exact example of a single SQL Server trigger that handles all (3) three conditions of the trigger actions INSERT, UPDATE, and DELETE. I finally found a line of text that talked about the fact that when a DELETE or UPDATE occurs, the common DELETED table will contain a record for these two actions. Based upon that information, I then created a small Action routine which determines why the trigger has been activated. This type of interface is sometimes needed when there is both a common configuration and a specific action to occur on an INSERT vs. UPDATE trigger. In these cases, to create a separate trigger for the UPDATE and the INSERT would become maintenance problem. (i.e. were both triggers updated properly for the necessary common data algorithm fix?)

To that end, I would like to give the following multi-trigger event code snippet for handling INSERT, UPDATE, DELETE in one trigger for an Microsoft SQL Server.

<pre><code>CREATE TRIGGER [dbo].[INSUPDDEL_MyDataTable]
ON [dbo].[MyDataTable] FOR INSERT, UPDATE, DELETE
AS 

-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with caller queries SELECT statements.
-- If an update/insert/delete occurs on the main table, the number of records affected
-- should only be based on that table and not what records the triggers may/may not
-- select.
SET NOCOUNT ON;

--
-- Variables Needed for this Trigger
-- 
DECLARE @PACKLIST_ID varchar(15)
DECLARE @LINE_NO smallint
DECLARE @SHIPPED_QTY decimal(14,4)
DECLARE @CUST_ORDER_ID varchar(15)
--
-- Determine if this is an INSERT,UPDATE, or DELETE Action
-- 
DECLARE @Action as char(1)
DECLARE @Count as int
SET @Action = 'I' -- Set Action to 'I'nsert by default.
SELECT @Count = COUNT(*) FROM DELETED
if @Count &gt; 0
 BEGIN
 SET @Action = 'D' -- Set Action to 'D'eleted.
 SELECT @Count = COUNT(*) FROM INSERTED
 IF @Count &gt; 0
 SET @Action = 'U' -- Set Action to 'U'pdated.
 END

if @Action = 'D'
 -- This is a DELETE Record Action
 --
 BEGIN
 SELECT @PACKLIST_ID =[PACKLIST_ID]
 ,@LINE_NO = [LINE_NO]
 FROM DELETED

 DELETE [dbo].[MyDataTable]
 WHERE [PACKLIST_ID]=@PACKLIST_ID AND [LINE_NO]=@LINE_NO
 END
 Else
 BEGIN
 --
 -- Table INSERTED is common to both the INSERT, UPDATE trigger
 --
 SELECT @PACKLIST_ID =[PACKLIST_ID]
 ,@LINE_NO = [LINE_NO]
 ,@SHIPPED_QTY =[SHIPPED_QTY]
 ,@CUST_ORDER_ID = [CUST_ORDER_ID]
 FROM INSERTED 

 if @Action = 'I'
 -- This is an Insert Record Action
 --
 BEGIN
 INSERT INTO [MyChildTable]
 (([PACKLIST_ID]
 ,[LINE_NO]
 ,[STATUS]
 VALUES
 (@PACKLIST_ID
 ,@LINE_NO
 ,'New Record'
 )
 END
 else
 -- This is an Update Record Action
 --
 BEGIN
 UPDATE [MyChildTable]
 SET [PACKLIST_ID] = @PACKLIST_ID
 ,[LINE_NO] = @LINE_NO
 ,[STATUS]='Update Record'
 WHERE [PACKLIST_ID]=@PACKLIST_ID AND [LINE_NO]=@LINE_NO
 END
 END 
</code></pre>

blocks|key|1369141|text|CREATE+TRIGGER+dbo.TableName_IUD
ON+dbo.TableName
AFTER+INSERT,+UPDATE,+DELETE
AS+
BEGIN
++++SET+NOCOUNT+ON;

++++--
++++--+Check+if+this+is+an+INSERT,+UPDATE+or+DELETE+Action.
++++--+
++++DECLARE+@action+as+char(1);

++++SET+@action+=+'I';+--+Set+Action+to+Insert+by+default.
++++IF+EXISTS(SELECT+*+FROM+DELETED)
++++BEGIN
++++++++SET+@action+=+
++++++++++++CASE
++++++++++++++++WHEN+EXISTS(SELECT+*+FROM+INSERTED)+THEN+'U'+--+Set+Action+to+Updated.
++++++++++++++++ELSE+'D'+--+Set+Action+to+Deleted.+++++++
++++++++++++END
++++END
++++ELSE+
++++++++IF+NOT+EXISTS(SELECT+*+FROM+INSERTED)+RETURN;+--+Nothing+updated+or+inserted.

++++...

++++END|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1369142|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>CREATE TRIGGER dbo.TableName_IUD
ON dbo.TableName
AFTER INSERT, UPDATE, DELETE
AS 
BEGIN
 SET NOCOUNT ON;

 --
 -- Check if this is an INSERT, UPDATE or DELETE Action.
 -- 
 DECLARE @action as char(1);

 SET @action = 'I'; -- Set Action to Insert by default.
 IF EXISTS(SELECT * FROM DELETED)
 BEGIN
 SET @action = 
 CASE
 WHEN EXISTS(SELECT * FROM INSERTED) THEN 'U' -- Set Action to Updated.
 ELSE 'D' -- Set Action to Deleted. 
 END
 END
 ELSE 
 IF NOT EXISTS(SELECT * FROM INSERTED) RETURN; -- Nothing updated or inserted.

 ...

 END
</code></pre>

blocks|key|1584314|text|这可能是一种更快的方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1584315|DECLARE+@action+char(1)

IF+COLUMNS_UPDATED()+>+0+--+insert+or+update
BEGIN
++++IF+EXISTS+(SELECT+*+FROM+DELETED)+--+update
++++++++SET+@action+=+'U'
++++ELSE
++++++++SET+@action+=+'I'
++++END
ELSE+--+delete
++++SET+@action+=+'D'|code-block|syntax|javascript|1584316|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This might be a faster way:

<pre><code>DECLARE @action char(1)

IF COLUMNS_UPDATED() &gt; 0 -- insert or update
BEGIN
 IF EXISTS (SELECT * FROM DELETED) -- update
 SET @action = 'U'
 ELSE
 SET @action = 'I'
 END
ELSE -- delete
 SET @action = 'D'
</code></pre>

blocks|key|1369246|text|所提供的两种解决方案的一个潜在问题是，根据它们的编写方式，更新查询可能更新零条记录，而插入查询可能插入零条记录。在这些情况下，插入和删除的记录集将为空。在许多情况下，如果插入和删除的记录集都为空，您可能只想退出触发器而不执行任何操作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1369247|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

A potential problem with the two solutions offered is that, depending on how they are written, an update query may update zero records and an insert query may insert zero records. In these cases, the Inserted and Deleted recordsets will be empty. In many cases, if both the Inserted and Deleted recordsets are empty you might just want to exit the trigger without doing anything.

blocks|key|1584436|text|如果运行不删除任何内容的delete语句，则不会考虑其中的许多建议。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1584437|假设您尝试删除ID等于表中不存在的某个值的位置。|1584438|您的触发器仍然会被调用，但删除或插入的表中没有任何内容。|1584439|为了安全起见，请使用以下代码：|1584440|--Determine+if+this+is+an+INSERT,UPDATE,+or+DELETE+Action+or+a+"failed+delete".
DECLARE+@Action+as+char(1);
++++SET+@Action+=+(CASE+WHEN+EXISTS(SELECT+*+FROM+INSERTED)
+++++++++++++++++++++++++AND+EXISTS(SELECT+*+FROM+DELETED)
++++++++++++++++++++++++THEN+'U'++--+Set+Action+to+Updated.
++++++++++++++++++++++++WHEN+EXISTS(SELECT+*+FROM+INSERTED)
++++++++++++++++++++++++THEN+'I'++--+Set+Action+to+Insert.
++++++++++++++++++++++++WHEN+EXISTS(SELECT+*+FROM+DELETED)
++++++++++++++++++++++++THEN+'D'++--+Set+Action+to+Deleted.
++++++++++++++++++++++++ELSE+NULL+--+Skip.+It+may+have+been+a+"failed+delete".+++
++++++++++++++++++++END)|code-block|syntax|javascript|1584441|特别感谢@KenDog和@Net_Prog的回答。|1584442|这是我从他们的脚本中构建的。|1584443|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|U|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|V|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|W|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

Many of these suggestions do not take into account if you run a delete statement that deletes nothing.
 Say you try to delete where an ID equals some value that does not exist in the table.
 Your trigger still gets called but there is nothing in the Deleted or Inserted tables.

Use this to be safe:

<pre><code>--Determine if this is an INSERT,UPDATE, or DELETE Action or a "failed delete".
DECLARE @Action as char(1);
 SET @Action = (CASE WHEN EXISTS(SELECT * FROM INSERTED)
 AND EXISTS(SELECT * FROM DELETED)
 THEN 'U' -- Set Action to Updated.
 WHEN EXISTS(SELECT * FROM INSERTED)
 THEN 'I' -- Set Action to Insert.
 WHEN EXISTS(SELECT * FROM DELETED)
 THEN 'D' -- Set Action to Deleted.
 ELSE NULL -- Skip. It may have been a "failed delete". 
 END)
</code></pre>

Special thanks to @KenDog and @Net_Prog for their answers.
 I built this from their scripts.

blocks|key|1369349|text|在第一个场景中，我假设您表有IDENTITY列|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1369350|CREATE+TRIGGER+[dbo].[insupddel_yourTable]+ON+[yourTable]
FOR+INSERT,+UPDATE,+DELETE
AS
IF+@@ROWCOUNT+=+0+return
SET+NOCOUNT+ON;
DECLARE+@action+nvarchar(10)
SELECT+@action+=+CASE+WHEN+COUNT(i.Id)+>+COUNT(d.Id)+THEN+'inserted'
++++++++++++++++++++++WHEN+COUNT(i.Id)+<+COUNT(d.Id)+THEN+'deleted'+ELSE+'updated'+END
FROM+inserted+i+FULL+JOIN+deleted+d+ON+i.Id+=+d.Id|code-block|syntax|javascript|1369351|在第二种情况下，不需要使用IDENTITTY列|1369352|CREATE+TRIGGER+[dbo].[insupddel_yourTable]+ON+[yourTable]
FOR+INSERT,+UPDATE,+DELETE
AS
IF+@@ROWCOUNT+=+0+return
SET+NOCOUNT+ON;
DECLARE+@action+nvarchar(10),
++++++++@insCount+int+=+(SELECT+COUNT(*)+FROM+inserted),
++++++++@delCount+int+=+(SELECT+COUNT(*)+FROM+deleted)
SELECT+@action+=+CASE+WHEN+@insCount+>+@delCount+THEN+'inserted'
++++++++++++++++++++++WHEN+@insCount+<+@delCount+THEN+'deleted'+ELSE+'updated'+END|1369353|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

In first scenario I supposed that your table have IDENTITY column

<pre><code>CREATE TRIGGER [dbo].[insupddel_yourTable] ON [yourTable]
FOR INSERT, UPDATE, DELETE
AS
IF @@ROWCOUNT = 0 return
SET NOCOUNT ON;
DECLARE @action nvarchar(10)
SELECT @action = CASE WHEN COUNT(i.Id) &gt; COUNT(d.Id) THEN 'inserted'
 WHEN COUNT(i.Id) &lt; COUNT(d.Id) THEN 'deleted' ELSE 'updated' END
FROM inserted i FULL JOIN deleted d ON i.Id = d.Id
</code></pre>

In second scenario don't need to use IDENTITTY column

<pre><code>CREATE TRIGGER [dbo].[insupddel_yourTable] ON [yourTable]
FOR INSERT, UPDATE, DELETE
AS
IF @@ROWCOUNT = 0 return
SET NOCOUNT ON;
DECLARE @action nvarchar(10),
 @insCount int = (SELECT COUNT(*) FROM inserted),
 @delCount int = (SELECT COUNT(*) FROM deleted)
SELECT @action = CASE WHEN @insCount &gt; @delCount THEN 'inserted'
 WHEN @insCount &lt; @delCount THEN 'deleted' ELSE 'updated' END
</code></pre>

blocks|key|1369403|text|这对我来说很有用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1369404|declare+@action_type+int;
select+@action_type+=+case
+++++++++++++++++++++++when+i.id+is+not+null+and+d.id+is+++++null+then+1+--+insert
+++++++++++++++++++++++when+i.id+is+not+null+and+d.id+is+not+null+then+2+--+update
+++++++++++++++++++++++when+i.id+is+++++null+and+d.id+is+not+null+then+3+--+delete
+++++++++++++++++++++end
++from++++++inserted+i
++full+join+deleted++d+on+d.id+=+i.id|code-block|syntax|javascript|1369405|由于并非所有列都可以一次更新，因此您可以检查特定列是否正在被更新，如下所示：|1369406|IF+UPDATE([column_name])|1369407|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

This does the trick for me:

<pre><code>declare @action_type int;
select @action_type = case
 when i.id is not null and d.id is null then 1 -- insert
 when i.id is not null and d.id is not null then 2 -- update
 when i.id is null and d.id is not null then 3 -- delete
 end
 from inserted i
 full join deleted d on d.id = i.id
</code></pre>

Since not all columns can be updated at a time you can check whether a particular column is being updated by something like this:

<pre><code>IF UPDATE([column_name])
</code></pre>

blocks|key|1369431|text|只是简单的方法|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1369432|CREATE+TRIGGER+[dbo].[WO_EXECUTION_TRIU_RECORD]+ON+[dbo].[WO_EXECUTION]
WITH+EXECUTE+AS+CALLER
FOR+INSERT,+UPDATE
AS
BEGIN++

++select+@vars+=+[column]+from+inserted+
++IF+UPDATE([column])+BEGIN
++++--+do+update+action+base+on+@vars+
++END+ELSE+BEGIN
++++--+do+insert+action+base+on+@vars+
++END

END+|code-block|syntax|javascript|1369433|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

just simple way 

<pre><code>CREATE TRIGGER [dbo].[WO_EXECUTION_TRIU_RECORD] ON [dbo].[WO_EXECUTION]
WITH EXECUTE AS CALLER
FOR INSERT, UPDATE
AS
BEGIN 

 select @vars = [column] from inserted 
 IF UPDATE([column]) BEGIN
 -- do update action base on @vars 
 END ELSE BEGIN
 -- do insert action base on @vars 
 END

END 
</code></pre>

blocks|key|1369469|text|DECLARE+@INSERTEDCOUNT+INT,
++++++++@DELETEDCOUNT+INT

SELECT+@INSERTEDCOUNT+=+COUNT([YourColumnName])+FROM+inserted

SELECT+@DELETEDCOUNT+=+COUNT([YourColumnName])+FROM+deleted|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1369470|如果它的升级|unstyled|1369471|+@INSERTEDCOUNT+=+1
+@DELETEDCOUNT+=+1|1369472|如果它的插入|1369473|+@INSERTEDCOUNT+=+1
+@DELETEDCOUNT+=+0|1369474|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|P|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$B|C]]|$1|I|3|J|5|F|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$B|C]]|$1|M|3|-4|5|F|7|T|8|@]|9|@]|A|$]]]|N|$]]

<pre><code>DECLARE @INSERTEDCOUNT INT,
 @DELETEDCOUNT INT

SELECT @INSERTEDCOUNT = COUNT([YourColumnName]) FROM inserted

SELECT @DELETEDCOUNT = COUNT([YourColumnName]) FROM deleted
</code></pre>

IF its updation

<pre><code> @INSERTEDCOUNT = 1
 @DELETEDCOUNT = 1
</code></pre>

if its insertion

<pre><code> @INSERTEDCOUNT = 1
 @DELETEDCOUNT = 0
</code></pre>

blocks|key|1584663|text|declare+@insCount+int
declare+@delCount+int
declare+@action+char(1)

select+@insCount+=+count(*)+from+INSERTED
select+@delCount+=+count(*)+from+DELETED

++++if(@insCount+>+0+or+@delCount+>+0)--if+something+was+actually+affected,+otherwise+do+nothing
++++Begin
++++++++if(@insCount+=+@delCount)
++++++++++++set+@action+=+'U'--is+update
++++++++else+if(@insCount+>+0)
++++++++++++set+@action+=+'I'+--is+insert
++++++++else
++++++++++++set+@action+=+'D'+--is+delete

++++++++--do+stuff+here
++++End|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1584664|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>declare @insCount int
declare @delCount int
declare @action char(1)

select @insCount = count(*) from INSERTED
select @delCount = count(*) from DELETED

 if(@insCount &gt; 0 or @delCount &gt; 0)--if something was actually affected, otherwise do nothing
 Begin
 if(@insCount = @delCount)
 set @action = 'U'--is update
 else if(@insCount &gt; 0)
 set @action = 'I' --is insert
 else
 set @action = 'D' --is delete

 --do stuff here
 End
</code></pre>

blocks|key|1584714|text|我正在使用下面的代码，它还可以正确地检测不删除任何内容的delete语句：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1584715|CREATE+TRIGGER+dbo.TR_TableName_TriggerName
++++ON+dbo.TableName
++++AFTER+INSERT,+UPDATE,+DELETE
AS
BEGIN
++++SET+NOCOUNT+ON;

++++IF+NOT+EXISTS(SELECT+*+FROM+INSERTED)
++++++++--+DELETE
++++++++PRINT+'DELETE';
++++ELSE
++++BEGIN
++++++++IF+NOT+EXISTS(SELECT+*+FROM+DELETED)
++++++++++++--+INSERT
++++++++++++PRINT+'INSERT';
++++++++ELSE
++++++++++++--+UPDATE
++++++++++++PRINT+'UPDATE';
++++END
END;|code-block|syntax|javascript|1584716|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I'm using the following, it also correctly detect delete statements that delete nothing:

<pre><code>CREATE TRIGGER dbo.TR_TableName_TriggerName
 ON dbo.TableName
 AFTER INSERT, UPDATE, DELETE
AS
BEGIN
 SET NOCOUNT ON;

 IF NOT EXISTS(SELECT * FROM INSERTED)
 -- DELETE
 PRINT 'DELETE';
 ELSE
 BEGIN
 IF NOT EXISTS(SELECT * FROM DELETED)
 -- INSERT
 PRINT 'INSERT';
 ELSE
 -- UPDATE
 PRINT 'UPDATE';
 END
END;
</code></pre>

blocks|key|1369698|text|我喜欢“优雅的计算机科学”的解决方案。我的解决方案在这里访问插入的和删除的伪表一次，以获得它们的状态，并将结果放入位映射变量中。然后，插入、更新和删除的每个可能的组合都可以通过有效的二进制评估在整个触发器中容易地进行测试(除了不太可能的插入或删除组合)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1369699|它确实假设如果没有修改任何行，那么DML语句是什么都无关紧要(这应该满足绝大多数情况)。因此，虽然它不像Roman+Pekar的解决方案那样完整，但它更有效。|1369700|使用这种方法，我们有可能在每个表中使用一个"FOR+INSERT，UPDATE，DELETE“触发器，让我们A)完全控制动作顺序，b)每个多动作适用的动作一个代码实现。(显然，每种实现模型都有其优缺点；您需要单独评估您的系统，以获得最好的效果。)|1369701|注意，"exists+(select+*+from«inserted/deleted»)“语句非常有效，因为没有磁盘访问(https://social.msdn.microsoft.com/Forums/en-US/01744422-23fe-42f6-9ab0-a255cdf2904a)。|offset|length|1369702|use+tempdb
;
create+table+dbo.TrigAction+(asdf+int)
;
GO
create+trigger+dbo.TrigActionTrig
on+dbo.TrigAction
for+INSERT,+UPDATE,+DELETE
as
declare+@Action+tinyint
;
--+Create+bit+map+in+@Action+using+bitwise+OR+"%7C"
set+@Action+=+(--+1:+INSERT,+2:+DELETE,+3:+UPDATE,+0:+No+Rows+Modified+
++(select+case+when+exists+(select+*+from+inserted)+then+1+else+0+end)
%7C+(select+case+when+exists+(select+*+from+deleted+)+then+2+else+0+end))
;
--+21+<-+Binary+bit+values
--+00+->+No+Rows+Modified
--+01+->+INSERT+--+INSERT+and+UPDATE+have+the+1+bit+set
--+11+->+UPDATE+<
--+10+->+DELETE+--+DELETE+and+UPDATE+have+the+2+bit+set

raiserror(N'@Action+=+%25d',+10,+1,+@Action)+with+nowait
;
if+(@Action+=+0)+raiserror(N'No+Data+Modified.',+10,+1)+with+nowait
;
--+do+things+for+INSERT+only
if+(@Action+=+1)+raiserror(N'Only+for+INSERT.',+10,+1)+with+nowait
;
--+do+things+for+UPDATE+only
if+(@Action+=+3)+raiserror(N'Only+for+UPDATE.',+10,+1)+with+nowait
;
--+do+things+for+DELETE+only
if+(@Action+=+2)+raiserror(N'Only+for+DELETE.',+10,+1)+with+nowait
;
--+do+things+for+INSERT+or+UPDATE
if+(@Action+&+1+=+1)+raiserror(N'For+INSERT+or+UPDATE.',+10,+1)+with+nowait
;
--+do+things+for+UPDATE+or+DELETE
if+(@Action+&+2+=+2)+raiserror(N'For+UPDATE+or+DELETE.',+10,+1)+with+nowait
;
--+do+things+for+INSERT+or+DELETE+(unlikely)
if+(@Action+in+(1,2))+raiserror(N'For+INSERT+or+DELETE.',+10,+1)+with+nowait
--+if+already+"return"+on+@Action+=+0,+then+use+@Action+<+3+for+INSERT+or+DELETE
;
GO

set+nocount+on;

raiserror(N'
INSERT+0...',+10,+1)+with+nowait;
insert+dbo.TrigAction+(asdf)+select+top+0+object_id+from+sys.objects;

raiserror(N'
INSERT+3...',+10,+1)+with+nowait;
insert+dbo.TrigAction+(asdf)+select+top+3+object_id+from+sys.objects;

raiserror(N'
UPDATE+0...',+10,+1)+with+nowait;
update+t+set+asdf+=+asdf+/1+from+dbo.TrigAction+t+where+asdf+<>+asdf;

raiserror(N'
UPDATE+3...',+10,+1)+with+nowait;
update+t+set+asdf+=+asdf+/1+from+dbo.TrigAction+t;

raiserror(N'
DELETE+0...',+10,+1)+with+nowait;
delete+t+from+dbo.TrigAction+t+where+asdf+<+0;

raiserror(N'
DELETE+3...',+10,+1)+with+nowait;
delete+t+from+dbo.TrigAction+t;
GO

drop+table+dbo.TrigAction
;
GO|code-block|syntax|javascript|1369703|entityMap|0|LINK|mutability|MUTABLE|url|https://social.msdn.microsoft.com/Forums/en-US/01744422-23fe-42f6-9ab0-a255cdf2904a^0|0|0|0|1P|2B|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Z|8|@]|9|@$H|10|I|11|1|12]]|A|$]]|$1|J|3|K|5|L|7|13|8|@]|9|@]|A|$M|N]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

I like solutions that are "computer science elegant." My solution here hits the [inserted] and [deleted] pseudotables once each to get their statuses and puts the result in a bit mapped variable. Then each possible combination of INSERT, UPDATE and DELETE can readily be tested throughout the trigger with efficient binary evaluations (except for the unlikely INSERT or DELETE combination). 

It does make the assumption that it does not matter what the DML statement was if no rows were modified (which should satisfy the vast majority of cases). So while it is not as complete as Roman Pekar's solution, it is more efficient.

With this approach, we have the possibility of one "FOR INSERT, UPDATE, DELETE" trigger per table, giving us A) complete control over action order and b) one code implementation per multi-action-applicable action. (Obviously, every implementation model has its pros and cons; you will need to evaluate your systems individually for what really works best.)

Note that the "exists (select * from «inserted/deleted»)" statements are very efficient since there is no disk access (<a href="https://social.msdn.microsoft.com/Forums/en-US/01744422-23fe-42f6-9ab0-a255cdf2904a" rel="nofollow">https://social.msdn.microsoft.com/Forums/en-US/01744422-23fe-42f6-9ab0-a255cdf2904a</a>).

<pre><code>use tempdb
;
create table dbo.TrigAction (asdf int)
;
GO
create trigger dbo.TrigActionTrig
on dbo.TrigAction
for INSERT, UPDATE, DELETE
as
declare @Action tinyint
;
-- Create bit map in @Action using bitwise OR "|"
set @Action = (-- 1: INSERT, 2: DELETE, 3: UPDATE, 0: No Rows Modified 
 (select case when exists (select * from inserted) then 1 else 0 end)
| (select case when exists (select * from deleted ) then 2 else 0 end))
;
-- 21 &lt;- Binary bit values
-- 00 -&gt; No Rows Modified
-- 01 -&gt; INSERT -- INSERT and UPDATE have the 1 bit set
-- 11 -&gt; UPDATE &lt;
-- 10 -&gt; DELETE -- DELETE and UPDATE have the 2 bit set

raiserror(N'@Action = %d', 10, 1, @Action) with nowait
;
if (@Action = 0) raiserror(N'No Data Modified.', 10, 1) with nowait
;
-- do things for INSERT only
if (@Action = 1) raiserror(N'Only for INSERT.', 10, 1) with nowait
;
-- do things for UPDATE only
if (@Action = 3) raiserror(N'Only for UPDATE.', 10, 1) with nowait
;
-- do things for DELETE only
if (@Action = 2) raiserror(N'Only for DELETE.', 10, 1) with nowait
;
-- do things for INSERT or UPDATE
if (@Action &amp; 1 = 1) raiserror(N'For INSERT or UPDATE.', 10, 1) with nowait
;
-- do things for UPDATE or DELETE
if (@Action &amp; 2 = 2) raiserror(N'For UPDATE or DELETE.', 10, 1) with nowait
;
-- do things for INSERT or DELETE (unlikely)
if (@Action in (1,2)) raiserror(N'For INSERT or DELETE.', 10, 1) with nowait
-- if already "return" on @Action = 0, then use @Action &lt; 3 for INSERT or DELETE
;
GO

set nocount on;

raiserror(N'
INSERT 0...', 10, 1) with nowait;
insert dbo.TrigAction (asdf) select top 0 object_id from sys.objects;

raiserror(N'
INSERT 3...', 10, 1) with nowait;
insert dbo.TrigAction (asdf) select top 3 object_id from sys.objects;

raiserror(N'
UPDATE 0...', 10, 1) with nowait;
update t set asdf = asdf /1 from dbo.TrigAction t where asdf &lt;&gt; asdf;

raiserror(N'
UPDATE 3...', 10, 1) with nowait;
update t set asdf = asdf /1 from dbo.TrigAction t;

raiserror(N'
DELETE 0...', 10, 1) with nowait;
delete t from dbo.TrigAction t where asdf &lt; 0;

raiserror(N'
DELETE 3...', 10, 1) with nowait;
delete t from dbo.TrigAction t;
GO

drop table dbo.TrigAction
;
GO
</code></pre>

blocks|key|1369728|text|试试这个..。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1369729|ALTER+TRIGGER+ImportacionesGS+ON+dbo.Compra+
++++AFTER+INSERT,+UPDATE,+DELETE
AS
BEGIN
++--+idCompra+is+PK
++DECLARE+@vIdCompra_Ins+INT,@vIdCompra_Del+INT
++SELECT+@vIdCompra_Ins=Inserted.idCompra+FROM+Inserted
++SELECT+@vIdCompra_Del=Deleted.idCompra+FROM+Deleted
++IF+(@vIdCompra_Ins+IS+NOT+NULL+AND+@vIdCompra_Del+IS+NULL)++
++Begin
+++++--+Todo+Insert
++End
++IF+(@vIdCompra_Ins+IS+NOT+NULL+AND+@vIdCompra_Del+IS+NOT+NULL)
++Begin
+++++--+Todo+Update
++End
++IF+(@vIdCompra_Ins+IS+NULL+AND+@vIdCompra_Del+IS+NOT+NULL)
++Begin
+++++--+Todo+Delete
++End
END|code-block|syntax|javascript|1369730|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try this..

<pre><code>ALTER TRIGGER ImportacionesGS ON dbo.Compra 
 AFTER INSERT, UPDATE, DELETE
AS
BEGIN
 -- idCompra is PK
 DECLARE @vIdCompra_Ins INT,@vIdCompra_Del INT
 SELECT @vIdCompra_Ins=Inserted.idCompra FROM Inserted
 SELECT @vIdCompra_Del=Deleted.idCompra FROM Deleted
 IF (@vIdCompra_Ins IS NOT NULL AND @vIdCompra_Del IS NULL) 
 Begin
 -- Todo Insert
 End
 IF (@vIdCompra_Ins IS NOT NULL AND @vIdCompra_Del IS NOT NULL)
 Begin
 -- Todo Update
 End
 IF (@vIdCompra_Ins IS NULL AND @vIdCompra_Del IS NOT NULL)
 Begin
 -- Todo Delete
 End
END
</code></pre>

blocks|key|1584803|text|Declare+@Type+varchar(50)='';
IF+EXISTS+(SELECT+*+FROM+inserted)+and++EXISTS+(SELECT+*+FROM+deleted)
BEGIN
++++SELECT+@Type+=+'UPDATE'
END
ELSE+IF+EXISTS(SELECT+*+FROM+inserted)
BEGIN
++++SELECT+@Type+=+'INSERT'
END
ElSE+IF+EXISTS(SELECT+*+FROM+deleted)
BEGIN
++++SELECT+@Type+=+'DELETE'
END|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1584804|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>Declare @Type varchar(50)='';
IF EXISTS (SELECT * FROM inserted) and EXISTS (SELECT * FROM deleted)
BEGIN
 SELECT @Type = 'UPDATE'
END
ELSE IF EXISTS(SELECT * FROM inserted)
BEGIN
 SELECT @Type = 'INSERT'
END
ElSE IF EXISTS(SELECT * FROM deleted)
BEGIN
 SELECT @Type = 'DELETE'
END
</code></pre>

blocks|key|1369797|text|虽然我也喜欢@Alex发布的答案，但我提供了@Graham上面的解决方案的这个变体|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1369798|这将独占地使用插入和更新的表中的记录存在，而不是使用COLUMNS_UPDATED进行第一次测试。它还为偏执的程序员提供了解脱，因为他们知道最后的情况已经被考虑……|1369799|declare+@action+varchar(4)
++++IF+EXISTS+(SELECT+*+FROM+INSERTED)
++++++++BEGIN
++++++++++++IF+EXISTS+(SELECT+*+FROM+DELETED)+
++++++++++++++++SET+@action+=+'U'++--+update
++++++++++++ELSE
++++++++++++++++SET+@action+=+'I'++--insert
++++++++END
++++ELSE+IF+EXISTS+(SELECT+*+FROM+DELETED)
++++++++SET+@action+=+'D'++--+delete
++++else+
++++++++set+@action+=+'noop'+--no+records+affected
--print+@action|code-block|syntax|javascript|1369800|您将使用如下语句获得NOOP：|1369801|update+tbl1+set+col1='cat'+where+1=2|1369802|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

while i do also like the answer posted by @Alex, i offer this variation to @Graham's solution above

this exclusively uses record existence in the INSERTED and UPDATED tables, as opposed to using COLUMNS_UPDATED for the first test. 
It also provides the paranoid programmer relief knowing that the final case has been considered... 

<pre><code>declare @action varchar(4)
 IF EXISTS (SELECT * FROM INSERTED)
 BEGIN
 IF EXISTS (SELECT * FROM DELETED) 
 SET @action = 'U' -- update
 ELSE
 SET @action = 'I' --insert
 END
 ELSE IF EXISTS (SELECT * FROM DELETED)
 SET @action = 'D' -- delete
 else 
 set @action = 'noop' --no records affected
--print @action
</code></pre>

you will get NOOP with a statement like the following : 

<pre><code>update tbl1 set col1='cat' where 1=2
</code></pre>

blocks|key|1369806|text|declare+@result+as+smallint
declare+@delete+as+smallint+=+2
declare+@insert+as+smallint+=+4
declare+@update+as+smallint+=+6
SELECT+@result+=+POWER(2*(SELECT+count(*)+from+deleted),1)+%2B+POWER(2*(SELECT+
+++++count(*)+from+inserted),2)

if+(@result+&+@update+=+@update)+
BEGIN
++print+'update'
++SET+@result=0
END
if+(@result+&+@delete+=+@delete)
++print+'delete'
if+(@result+&+@insert+=+@insert)
++print+'insert'|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1369807|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>declare @result as smallint
declare @delete as smallint = 2
declare @insert as smallint = 4
declare @update as smallint = 6
SELECT @result = POWER(2*(SELECT count(*) from deleted),1) + POWER(2*(SELECT 
 count(*) from inserted),2)

if (@result &amp; @update = @update) 
BEGIN
 print 'update'
 SET @result=0
END
if (@result &amp; @delete = @delete)
 print 'delete'
if (@result &amp; @insert = @insert)
 print 'insert'
</code></pre>

blocks|key|1584905|text|我这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1584906|select+isnull((select+top+1+1+from+inserted+t1),0)+%2B+isnull((select+top+1+2+from+deleted+t1),0)|code-block|syntax|javascript|1584907|1个->插件|1584908|2+->删除|1584909|3+->更新|1584910|set+@i+=+isnull((select+top+1+1+from+inserted+t1),0)+%2B+isnull((select+top+1+2+from+deleted+t1),0)
--select+@i

declare+@action+varchar(1)+=+case+@i+when+1+then+'I'+when+2+then+'D'+when+3+then+'U'+end
--select+@action


select+@action+c1,*+from+inserted+t1+where+@i+in+(1,3)+union+all
select+@action+c1,*+from+deleted+t1+where+@i+in+(2)|1584911|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

i do this:
<pre><code>select isnull((select top 1 1 from inserted t1),0) + isnull((select top 1 2 from deleted t1),0)
</code></pre>
1 -&gt; insert
2 -&gt; delete
3 -&gt; update
<pre><code>set @i = isnull((select top 1 1 from inserted t1),0) + isnull((select top 1 2 from deleted t1),0)
--select @i

declare @action varchar(1) = case @i when 1 then 'I' when 2 then 'D' when 3 then 'U' end
--select @action


select @action c1,* from inserted t1 where @i in (1,3) union all
select @action c1,* from deleted t1 where @i in (2)
</code></pre>

blocks|key|1584926|text|DECLARE+@ActionType+CHAR(6);
SELECT++@ActionType+=+COALESCE(CASE+WHEN+EXISTS(SELECT+*+FROM+INSERTED)
+++++++++++++++++++++++++++++++++++++AND+EXISTS(SELECT+*+FROM+DELETED)++THEN+'UPDATE'+END,
+++++++++++++++++++++++++++++++CASE+WHEN+EXISTS(SELECT+*+FROM+DELETED)++THEN+'DELETE'+END,
+++++++++++++++++++++++++++++++CASE+WHEN+EXISTS(SELECT+*+FROM+INSERTED)+THEN+'INSERT'+END);
PRINT+++@ActionType;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1584927|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>DECLARE @ActionType CHAR(6);
SELECT @ActionType = COALESCE(CASE WHEN EXISTS(SELECT * FROM INSERTED)
 AND EXISTS(SELECT * FROM DELETED) THEN 'UPDATE' END,
 CASE WHEN EXISTS(SELECT * FROM DELETED) THEN 'DELETE' END,
 CASE WHEN EXISTS(SELECT * FROM INSERTED) THEN 'INSERT' END);
PRINT @ActionType;
</code></pre>

I need to write an Insert, Update Trigger on table A which will delete all rows from table B whose one column (say Desc) has values like the value inserted/updated in the table A's column (say Col1). How would I go around writing it so that I can handle both Update and Insert cases. How would I determine if the trigger is executed for an update or insert.

Insert Update trigger how to determine if insert or update

SQL Server

我需要在表A上编写一个Insert，Update触发器，它将删除表B中的所有行，这些行的一列(比如Desc)的值类似于表A的列(比如Col1)中插入/更新的值。我该如何编写它才能处理Update和Insert两种情况？如何确定触发器是为update还是insert执行的。

问插入更新触发器如何确定Insert或Update
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问插入更新触发器如何确定Insert或UpdateEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问插入更新触发器如何确定Insert或Update
EN