>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
Check
http://www.developersdex.com/sql/message.asp?p=580&r=5790266e.g. if exists (select 1 from deleted) and exists (select 1 from inserted)
' update
BTW, you have better control in different databases for this question, as I just learned.
http://www.postgresql.org/docs/8.0/interactive/plpgsql-trigger.html
If it's not broken, fix it until it is.
My Blog