Monday, 15 August 2011

SQL server Maximum insert statement limit for batch insert -


The maximum statement limit for the batch entry is -

  Insert it ... .; Put in .....; Put in .....; Put in .....; According to, the length of the string with the SQL statement is 65,536 times the network packet size, with the default packet size of 4K. 

(Thanks for explanation @ DNN_A_Anlevive)


No comments:

Post a Comment