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?
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.