Determine what event fired the 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)

Determine what event fired the trigger

Author

Topic

tramvai
Starting Member

7 Posts

Posted - 2009-04-27 : 20:06:47

Hello.

I have to use a single trigger for all Update/Insert events. How can i determine which event has caused the trigger to fire?

I need different actions on Update and Insert.

For example

CREATE TRIGGER trigger1
on table1
AFTER INSERT,UPDATE

AS
BEGIN

if insert
do something

if update
do something else

Give me an A ... ARSENAL

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-04-28 : 01:33:25

[code]
if not exists (select * from deleted)
begin
-- event was insert
end
else
begin
-- event was update
end
[/code]

Webfred

No, you're never too old to Yak'n'Roll if you're too young to die.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources