How to do batch insert when there is no identity column?
<p>Table with million rows, two columns.</p>

<pre><code>code | name
xyz  | product1
abc  | Product 2
...
...
</code></pre>

<p>I want to do insert in small batches (10000) via the insert into/select query.</p>

<p>How can we do this when there is no identity key to create a batch?</p>