How can we help you today? How can we help you today?

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

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.
doug
0

Comments

2 comments

Sort by
  • Homer
    The rows returned were more than the 1000 limit for the values statement.
    Homer
    0
  • 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>
    Jessica R
    0

Add comment

Please sign in to leave a comment.