How to fix The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values.

Question

How to fix The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values.

Answer 1

Try to split the statement. For example, replace

insert Table1 values
( 1, 2, 3 ),
( 4, 5, 6 ),
( 7, 8, 9 )

with

insert Table1 values
( 1, 2, 3 ),
( 4, 5, 6 )
insert Table1 values
( 7, 8, 9 )

Each fragment should not exceed the maximum allowed number of 1000 row values.

Answer 2

Hi @Rabia Kurnaz

Or you can try the workaround mentioned in this thread.

https://stackoverflow.com/questions/7737472/how-can-i-insert-100000-rows-in-sql-server

Best regards,

Percy Tang

---

If the answer is the right solution, please click "Accept Answer". If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

The number of row value expressions

You provide very lerss informations and so we have to guess:

You have an INSERT statement with a lot of fix VALUE in the manner of

INSERT INTO yourTable (Column1)
VALUES (1), (2), (3), ..

exceeds the maximum allowed number of 1000 row values.

The do what the error imply, reduce the count of values and split the INSERT statement into several ones.