title: SQL Server Maximum rows that can be inserted in a single insert statment
body: <p>I want to do a batch insert, similar to this question </p>
  
  <p><a href="https://stackoverflow.com/questions/5526917/how-to-do-a-batch-insert-in-mysql">How to do a batch insert in MySQL</a></p>
  
  <ol>
  <li><p>What is the limitation is SQL Server on how many rows can be inserted in a single insert statement ?</p></li>
  <li><p>What happens when for example the first value is inserted but the second one causes a primary key violation. Are the all <code>INSERT</code> statements rolled back?</p></li>
  </ol>
  
  <pre><code>INSERT INTO tbl_name (a,b) 
  VALUES (1, 2), (1, 3));
  </code></pre>