title: How to execute multiple "insert into values" Statement at once in Microsoft SQL Server
body: <p>I am executing statement </p>
  
  <pre><code>insert into [dbo].[Table_1] 
  values ('43546354354', '35435454351', 'vvish', GETDATE(), 'vvish', GETDATE())
  </code></pre>
  
  <p>There are total of 154,155 lines.I tried and I go the following error.</p>
  
  <blockquote>
    <p>The script exceeds the Transact-SQL IntelliSense maximum script size setting. You can change the setting on the Text Editor/Transact-SQL/IntelliSense Page in the Tools/Options menu.</p>
  </blockquote>
  
  <p>I also went to Tools=>Options=>TextEditor=>Transact-sql=>Intellisense and increase "Maximum script size to 5MB".</p>
  
  <p>I tried moving the lines  of each 50,000 to different scripts but its taking very long time for me to move and execute. I have many other scripts with same size. Any suggestions please do help me.    </p>