title: How to determine if anything changed in update trigger in t-sql
body: <p>How can I determine if something has changed in UPDATE trigger? For example I have table named person with only one column NAME which contains value 'Mike'. If I run </p>
  
  <pre><code>UPDATE person SET NAME = 'Mike' 
  </code></pre>
  
  <p>how can I determine in the update trigger that nothing has changed? I know about 
      UPDATE(col) 
  statement, but I don't want to iterate over columns. Is there any other way to accomplish this?</p>