>Hi,
>
>Can you have one trigger for both INSTEAD OF DELETE and UPDATE, as shown in the title of this thread? And if yes, how would you distinguish inside the trigger if it was called by UPDATE or DELETE action?
>
>TIA.
Of course you can, but both should be INSTEAD OF triggers.
To distinguish which records are deleted, and which is updated you must use INSERTED and DELETED pseudo tables.
All records that are in both tables are updated, all record that are only in DELETED table are deleted.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.