atomic of store procedure

not atomic: The procedure neither committed, nor rolled back and this remains to be done for the complete unit of work in which the SQL procedure was called.

atomic: If any unhandled error conditions arise within it, all statements that have executed up to that point are considered to have failed as well and are therefore rolled back.个人发现atomic也需要其调用的客户端去完成UOW。

Atomic compound statements cannot be nested inside other ATOMIC compound statements.

You cannot use the SAVEPOINT statement, the COMMIT statement, or the ROLLBACK statement from within an ATOMIC compound statement. These are only supported in NOT ATOMIC compound statements within SQL procedures.