title: SQL Server trigger on insert and how to reference the data that was inserted
body: <p>High level I have two tables that need to have some of the data mirrored. I can't go through and change all of the code to write to both so I thought I'd use a SQL trigger to insert data into the 2nd table anytime data is inserted into the 1st. Here is where I am stuck:</p>
  
  <pre><code>CREATE TRIGGER new_trigger_INSERT
  ON old_table
  FOR INSERT
  INSERT INTO new_table (id, first_name, last_name)
  VALUES () --This is where I'm lost, I need to insert some of the data from the insert that executed this trigger
  </code></pre>
  
  <p>Any help is appreciated, also if there is a better way to accomplish this let me know.</p>