INSERT INTO TableName( Colum1) VALUES (3) INSERT INTO TableName( Colum1) VALUES (2)
INSERT INTO TableName( Colum1) VALUES (1) In the above scenario if any row insert causes an error the whole statement will be rolled back and none of the rows will be inserted.īut if you were inserting rows with a separate statement for each row i.e. Well if you are inserting rows using multi-value construct INSERT INTO TableName( Colum1) What happens when an error occurs during an insert. INSERT INTO TableName( Colum1)īut if your are using a SELECT statement to insert rows in a table, there is no limit for that, something like. The Maximum number of rows you can insert in one statement is 1000 when using INSERT INTO.
0 kommentar(er)
