Options
Why does the sql prompt "Script as Insert" keep repeating the insert into in the generated script
Homer
Posts: 2 New member
in SQL Prompt
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.
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
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?