title: Insert Into Table1 Select x, y, z From Table2 Where x = 1
body: <p>In mssql is it possible to run this query:</p>
  
  <pre><code>Insert Into Table1 Select x, y, z From Table2 Where x = 1
  </code></pre>
  
  <p>when Table1 has an id column that is identity &amp; auto-incrementing </p>
  
  <p>I am getting the following error:</p>
  
  <p>Msg 8101, Level 16, State 1, Line 1
  An explicit value for the identity column in table 'table1' can only be specified when a column list is used and IDENTITY_INSERT is ON.</p>