Skip to main content
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?

@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