Why does the sql prompt "Script as Insert" keep repeating the insert into in the generated script

Homer

for example
Insert into #temptable
Values(1)
Insert into #temptable
Values(2)

There used to be one insert statement and 2 values statements in this case.

Homer

The rows returned were more than the 1000 limit for the values statement.

Jessica R

Thanks @Homer!

As you mentioned, the maximum number of rows you can insert in one statement is 1000 when using INSERT INTO ... VALUES... which is the reason why multiple INSERT INTO statements were generated.<br><br><br>