MS SQL Trigger only for insert.

[Mayank Tripathi]

Hi,
I want to know how to restrict the trigger to get fire while updating records in a table.
I am applying trigger on a table for insert. And don't want trigger to get fire when the record get update.

[ck9663]

You can disable the trigger prior to table update (insert, delete or update) then enable it after.

Happy Coding!!!


~~ CK