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

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

Last Updated: March 26, 2019