title: How to insert Auto-Increment using SELECT INTO Statement? SQL SERVER
body: <p>This my table1:</p>
  
  <pre><code>Name        Description  
  john        student       
  dom         teacher
  </code></pre>
  
  <p>I need to use <code>SELECT * INTO</code> to transfer it to another table (<code>table2</code>) but I want it with a new column named <code>Auto</code> which is <strong>auto-incremented</strong>. </p>
  
  <p>Which will look like this:</p>
  
  <pre><code>Name       Description        Auto
  John        Student            1
  Dom         Teacher            2
  </code></pre>
  
  <p>Current Code: <code>SELECT * INTO table2 FROM table1</code></p>