No. SQL's rules are that data modification statements are atomic, they either complete entirely or fail entirely.

You'll need extra logic in the insert to ensure that SQL only tries to insert rows that are valid.