i have the following trigger created on a table, I need to know if it's possible and how I would do this. what i need to know is if a column is updated then fire the trigger, the insert part works fine as it stands now. but I don't want it to create the new record in the table the trigger is writing to if any column is updated on the record.
I hope this makes since.
here is the trigger statement
ALTER trigger [dbo].[badge_Print_history] on
for Insert, update