title: SQL Server trigger - copy row before updating
body: <p>I'd like to copy a table's row before updating and I'm trying to do it like this:</p>
  
  <pre><code>CREATE TRIGGER first_trigger_test
  on Triggertest
  FOR UPDATE
  AS
  insert into Triggertest select * from Inserted
  </code></pre>
  
  <p>Unfortunately, I get the error message</p>
  
  <pre><code>Msg 8101, Level 16, State 1, Procedure first_trigger_test, Line 6
  An explicit value for the identity column in table 'Triggertest' can only be specified when a column list is used and IDENTITY_INSERT is ON.
  </code></pre>
  
  <p>I assume it's because of the id-column; can't I do something like 'except' id? I do not want to list all the columns in the trigger as it should be as dynamic as possible...</p>