本文介绍了如何确定是插入还是更新的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
每当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更多推荐
如何确定是插入还是更新
发布评论