如何确定是插入还是更新 [英] How to determine if insert or update

问题描述

每当CUSTOMER表中发生INSERT时，我都需要调用 StoredProcedure1 ，而CUSTOMER表中发生
UPDATE，则需要调用 StoredProcedure2 。
如何从SQL Server 2008中确定是在触发器中插入还是更新。

Whenever INSERT is happened in the CUSTOMER table,I need to call the "StoredProcedure1"and UPDATE is happend in the CUSTOMER table,I need to call the "StoredProcedure2" in the Trigger. How to determine if insert or update in the trigger from SQL Server 2008.

有些人可以帮助我如何解决？

Some one can please help me how to solve?

代码：

CREATE TRIGGER Notifications ON CUSTOMER
FOR INSERT,UPDATE
AS
BEGIN
DECLARE @recordId varchar(20);
set @recordId= new.Id;
    //if trigger is insert at the time I call to SP1
        EXEC StoredProcedure1 @recordId
    //if trigger is Upadeted at the time I call to SP2
        EXEC StoredProcedure2 @recordId
END

推荐答案

尝试使用此代码来触发插入，更新和删除。如果在Microsoft SQL SERVER 2008上正常运行，则可以正常工作。

Try this code for trigger for INSERT, UPDATE and DELETE. This works fine on Microsoft SQL SERVER 2008

if (Select Count(*) From inserted) > 0 and (Select Count(*) From deleted) = 0
begin
   print ('Insert...')
end

if (Select Count(*) From inserted) = 0 and (Select Count(*) From deleted) > 0
begin
   print ('Delete...')
end

if (Select Count(*) From inserted) > 0 and (Select Count(*) From deleted) > 0
begin
   print ('Update...')
end

这篇关于如何确定是插入还是更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！