Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Detecting Insert vs Update Trigger event
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Detecting Insert vs Update Trigger event
Versions des environnements
SQL Server:
SQL Server 7.0
Divers
Thread ID:
01232029
Message ID:
01232029
Vues:
53
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform