Category: SQL Server 2005, T-SQL
I have an insert trigger on TableA that updates Column1 in TableA. I also have an update trigger on TableA that I don't want to fire, or at least not to execute certain code, when a new record is inserted in the table. How can this be achieved?
I don't want to use a computed column instead of the update statement in the insert trigger -- the value has to be static, and I don't want performance hit when selecting from the table.
Thanks,
Leo
Software/Hardware used:
ASKED:
April 22, 2008 5:34 PM
UPDATED:
April 23, 2008 2:33 PM