Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Detecting Insert vs Update Trigger event
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Detecting Insert vs Update Trigger event
Environment versions
SQL Server:
SQL Server 7.0
Miscellaneous
Thread ID:
01232029
Message ID:
01232029
Views:
54
Hi all,

I have a trigger that I'm trying to modify. It needs to be run on EITHER an Insert OR an Update and have it as...

ALTER TRIGGER dbo.somast_email_credit ON somast
AFTER UPDATE, insert
AS

...
...
...


Now, while in the trigger, is there some @@ variable, or trigger status that identifies if it was triggerd by an Insert vs an Update?

Thanks
Next
Reply
Map
View

Click here to load this message in the networking platform