SQL Server Maximum rows that can be inserted in a single insert statement

March 26, 2019

The Maximum number of rows you can insert in one statement is 1000 when using INSERT INTO ... VALUES.

INSERT INTO TableName( Colum1)

VALUES (1),

       (2),

       (3),...... upto 1000 rows. 

But if your are using a SELECT statement to insert rows in a table, there is no limit for that.

INSERT INTO TableName (ColName)

Select Col FROM AnotherTable

Tweet