Insert encounters duplicate key

M

mscertified

If I do an INSERT based on a subselect i.e. its going to insert multiple
records, and some of the records to be added fail on a duplicate key, will
the INSERT successfully insert the rest of the records or will it give up
when it encounters the first duplicate?
Thanks.
 
Top