title: Conditional Update stored proc is firing a trigger always
body: <p>I have a stored procedure that says</p>
  
  <pre><code>update table1 set value1 = 1 where value1 = 0 and date &lt; getdate() 
  </code></pre>
  
  <p>I have a trigger that goes like </p>
  
  <pre><code>CREATE TRIGGER NAME ON TABLENAME
  FOR UPDATE
  ...
  if UPDATE(value1) 
  BEGIN
  --Some code to figure out that this trigger has been called
  -- the value is always null
  END
  </code></pre>
  
  <p>Any idea why this trigger is called even when the stored procedure does not update any values? </p>