Sql to detect fields changed in update trigger (sql server 2005)?

Question

In sql server 2005, inside the update trigger, there is a way to find the list of fields \ columns that are modified by the original update request.

I have a table with 150 columns, and inside the trigger I need to write if ONLY one particular field has been updated or not (and no other field has been changed)

I can write a long sql to compare 150 columns, but it will be error prone and looks silly!

Any decent way to get around this. I hope some sql2005 api come to my aid.

Answer 1

COLUMNS_UPDATED - , . SQL Server Central.