Question

I am using loop to insert data from excel to database. It is getting failed after 999 rows insertion. Is there any limit to rows insertion?

  • 2 November 2022
  • 1 reply
  • 129 views

I am using loop to insert data from excel to database. It is getting failed after 999 rows insertion. Is there any limit to rows insertion?

1 reply

Userlevel 2
Badge +7

@Manish Vyas​  I know in SQL Server there is a 1000 row limit when inserting rows in a batch

e.g.

 

INSERT INTO dbo.MyTable (MyCol)

VALUES ('Value1'),('Value2')... etc.

 

Are you building up a large string and doing one insert or doing all the inserts individually?

Reply