CODEWITHSUNDEEP
sqlsql-server
user1049021
user1049021

Reputation: 257

SQL server Maximum insert statement limit for batch insert

what is maximum statement limit for batch insert like-

  Begin
      insert into..... ;
      insert into..... ;
      insert into..... ;
      insert into..... ;
  End

Upvotes: 2

Views: 1211

Answers (1)

A_Sk
A_Sk

Reputation: 4630

According to MSDN, the length of the string containing the SQL statement is 65,536 multiplied by the network packet size, with a default packet size of 4k.

(Thanks to @Damien_The_Unbeliever for the clarification)

Upvotes: 1

Related Questions