title: Create a trigger that inserts values into a new table when a column is updated
body: <p>I've been looking at some previous answers on triggers on here but can't find what I need exactly but I'm sure my question  has been asked/answered before.</p>
  
  <p>I'm trying to keep track of any changes to columnA and columnB in table1.</p>
  
  <p>If this value changes I want to keep track of the values by inserting the existing value and the new Value into a different table with a date.</p>
  
  <p>I've been looking at using something like this for the insert but not sure how to add get the existing and new values of the source table (table1):</p>
  
  <pre><code>CREATE TRIGGER NewTrigger ON table1
  FOR INSERT
  AS
  
  INSERT INTO table2
          (columnA , columnB, todaysDate)
      .
      .
  
  go
  </code></pre>
  
  <p>I need to use (I think) the </p>
  
  <pre><code>Before update ON table1 FOR EACH ROW
     .
     .
     .
  BEGIN
  </code></pre>
  
  <p>and look through all the changes and insert these first then do the same after the Update?</p>