What are the challenges you face when working across database platforms? Take the survey
Options

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

HomerHomer Posts: 2 New member
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.
Tagged:

Answers

  • Options
    HomerHomer Posts: 2 New member
    The rows returned were more than the 1000 limit for the values statement.
  • Options
    Jessica RJessica R Posts: 1,319 Rose Gold 4
    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 Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


Sign In or Register to comment.