title: SQL Update trigger column name
body: <p>can't seem to find a way to do this anywhere. I have an SQL trigger that fires on an update. The trigger copies some details about the update to another table that someone elses program uses. Among the details passed is the name of the updated column. There a many, many, potential columns that have been updated (although only one at any one time), and I could just use something like:</p>
  
  <pre><code>IF UPDATE(ThisColumn)
  BEGIN
     Do stuff with ThisColumn
  END
  IF UPDATE(ThatColumn)
  BEGIN
     Do same stuff with ThatColumn
  END
  </code></pre>
  
  <p>But as I said there are many columns in this table and I'm sure there must be an elgant way to get the name of the column that has been updated without me typing pages of essentially the same IF statements.</p>
  
  <p>Thanks in advance!</p>