title: SQL Trigger - determine if a field has changed
body: <p>I have this trigger</p>
  
  <pre><code>ALTER TRIGGER [dbo].[tInsertTaskFromOpportunityReassignment] 
     ON [dbo].[OpportunityBase]
     FOR UPDATE
  AS 
  BEGIN
  
  IF UPDATE(owninguser)
  BEGIN
  -- do the task
  END
  END
  </code></pre>
  
  <p>I only want to do the task if owninguser has actually changed. How can I determine that?</p>
  
  <p>Thanks</p>