This is related to another question I asked, but striped down to just

When using the sql insert command "insert into ... " command on a multi-user system.

1. Is there a way checking if it was successfull?
2. if it failed can I revert other insert commands?

If answer to either is no, what are the alternatives?