inserting several rows at once.

[eja2000]

can you give me an example of a query that inserts all records in a view at once..eg

insert into xxx select all from view_name (will this work???)


what happens if one of the rows in the view does not get inserted?
will the whole thing fail?

thanks

 

[mrdenny]

Yes, the query sample you provided will work providing that the columns in the table match the columns being outputted by the view.

When doing a multi-row insert you are inserting all the rows in a single transaction. Because of this if one row fails the entire transaction is rolled back, and none of the rows are inserted.