chaithanya k

chaithanya k

  • NA
  • 51
  • 6.7k

Inserting Lakhs of Records At a time

Mar 10 2018 7:43 AM
I have 10 lakhs insert queries in a .sql file.
Is there any way to install all the queries at a time in sql server management studio?
When I try to do it it is raising System.OutOfMemory.Exception
Even I tried with sqlcmd command prompt but it given same result.
Thanks in Advance for suitable answer. 

Answers (4)