title: IF UPDATE() in SQL server trigger
body: <p>If there's:</p>
  
  <pre><code>IF UPDATE (col1)
  </code></pre>
  
  <p>...in the SQL server trigger on a table, does it return true only if col1 has been changed or been updated?</p>
  
  <p>I have a regular update query like</p>
  
  <pre><code>UPDATE table-name 
     SET col1 = 'x', 
         col2 =  'y' 
   WHERE id = 999
  </code></pre>
  
  <p>Now what my concern is if the "col1" was 'x' previously then again we updated it to 'x'
  would <code>IF UPDATE ("col1")</code> trigger return True or not?</p>
  
  <p>I am facing this problem as my save query is generic for all columns, but when I add this condition it returns True even if it's not changed...So I am concerned what to do in this case if I want to add condition like that?</p>