Get which event fired on trigger

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Get which event fired on trigger

Author

Topic

baburk
Posting Yak Master

108 Posts

Posted - 2009-04-02 : 08:14:36

Hi all,

I wrote a trigger

CREATE TRIGGER tr_IDU ON tableName
WITH EXECUTE AS CALLER
FOR INSERT, UPDATE, DELETE
AS
BEGIN

END

I want to get which event fired (i.e. INSERT, UPDATE, DELETE) inside the trigger.

Thanks.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-04-02 : 08:16:22

[code]CREATE TRIGGER tr_IDU ON tableName
WITH EXECUTE AS CALLER
FOR INSERT, UPDATE, DELETE
AS

DECLARE @Event VARCHAR(12)

IF EXISTS (SELECT * FROM inserted)
IF EXISTS (SELECT * FROM deleted)
SET @Event = 'Update'
ELSE
SET @Event = 'Insert'
ELSE
SET @Event = 'Delete'[/code]

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources