Hi, Bharat,

First, again, I recommend against using the UPDATE function, which will only tell you if a column is specified in an UPDATE statement. If I repeatedly issue the command...

UPDATE MyTable SET FirstName = 'Kevin'

...the UPDATE function will return a true for the firstname column, every time. You need to join the Inserted and Deleted columns to see if something truly "changed".

Also, I'm not sure if your code is going to work if a single UPDATE affects multiple rows. In SQL Server, an update trigger fires one per UPDATE statement. So make sure your code will handle an UPDATE that affect multiple rows.

The code you posted may "work", but will be compartively more difficult to manage. Imagine how complicated your logic will become once you start to add more and more columns to the mix.

You're probably better off reearching update triggers and doing some more reading, to get a stronger handle on how to manage something like this. If you're saying you're not that good at writing scripts, fine - but I would suggest you invest some time and make yourself better at it.

Kevin