How to insert Auto-Increment using SELECT INTO Statement? SQL SERVER
<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>