I don't understand the basic concepts, the more I see, the more I understand

雪兽冰牧

if @@ error> 0
rollback
else
commit

vgf10002

Still not clear
begin transaction
.......................
rollback

All successful, all cancelled; some successful, all cancelled

Since they are all cancelled, why do you need this keyword?

========================
This is just a theoretical example
Actually this is not the case
Generally, it is necessary to add a judgment
if ...
rollback
else
commit
This judgment is not necessarily an error judgment, it may be another judgment