title: "Batch auto-increment" IDs for multiple row insertion
body: <p>I am working in SQL Server 2017, and I have a table of the form:</p>
  
  <p><strong>tbl_current</strong></p>
  
  <pre><code>COL1   COL2
  -----------
   A      1
   B      3
   C     56
  </code></pre>
  
  <p>which I want to periodically insert into the table <code>tbl_release</code>.</p>
  
  <p>This table would have an extra ID column, which I'd like to auto-increment with each "batch insertion". For example, let's say I perform the the ingestion of <code>tbl_current</code> into <code>tbl_release</code>, it would look like this:</p>
  
  <p><strong>tbl_release</strong></p>
  
  <pre><code>ID   COL1   COL2
  ----------------
   1    A       1
   1    B       3
   1    C      56 
  </code></pre>
  
  <p>Now, let's say I perform another ingestion with the same data, it'd look like:</p>
  
  <p><strong>tbl_release</strong></p>
  
  <pre><code>ID   COL1   COL2
  ----------------
   1    A       1
   1    B       3
   1    C      56 
   2    A       1
   2    B       3
   2    C      56  
  </code></pre>
  
  <p>What is the best way to achieve this? Is there some SQL Server feature that would allow to achieve this, or do I need to run some sub-queries?</p>