Skip to content
Advertisement

SQL Server trigger on specific column updated

I have a table with the following columns:

The LM_TIME column will be set automatically by a trigger when any of the other column values get updated.

However I want the LM_TIME …. NOT to get updated by the trigger when the CLIENT_SYNCED_TIME column is updated.

I am using the below trigger right now, which updates the LM_TIME when any of the column value is changed.

Simply I just want to make the trigger not to worry about CLIENT_SYNCED_TIME column. What modifications I have to make to achieve this effect?

Advertisement

Answer

thanks to Mr. Bhosale

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement