title: How to Insert 1.2 million of Insert Command having in .sql file
body: <p>I have .sql file which contains 1200000 Insert command.,<br>
  When I am executing by opening in SQL SERVER MANAGEMENT it says  </p>
  
  <pre><code>Insufficient memory to continue the execution of program
  </code></pre>
  
  <p>I was thinking to execute directly command prompt but facing Issue tried this <code>sqlcmd -d database Name -i fileName.sql</code></p>
  
  <p>please Help.</p>