The answer is yes, although transactions are indeed atomic you could use a savepoint. So in your case, the code could look like this ... ... <看更多>

Unfortunately there are a number of errors in the answers so far with regard to how COMMIT works, so I'll add another one. See How It Works: Bob Dorr's SQL ... ... <看更多>