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

caboom04

begin transaction
.............
commit


begin transaction
.............
rollback


The same is transaction processing, I can't figure it out now.For example, I have N insert or update statements. I think if any one is not successful or interrupted for any reason, all insert or update operations will be canceled. In the case, whether to use commit or rollback, can you elaborate?
My question is that the book says that “commit” means that all the statements have been executed successfully, then commit; then what is the result?
Rollback is still the same problem. It is required to use rollback in the statement to roll back the error, but the final execution result is partially wrong.

prajna

commit: Confirm that the operation takes effect
rollback: rollback, operation does not take effect

caboom04

Still dizzy,
So for example:
insert into .......
insert into ......
insert into ..........
delete ........
delete .......
I want to execute the above five statements, I must ensure that each statement must be successfully executed, if one is not successfully executed, all operations must be canceled
How to write?

feiyun_1765

Support Can you explain the white point?

prajna

Judge with @@ error
Such as
begin transaction
.............

if @@ error> 0
rollback
else
commit

vgf10002

begin transaction
.............
commit

All successful, submitted, partially successful, all cancelled

begin transaction
.............
rollback

All successes, all cancellations; some successes, all cancellations

caboom04

I understand,
But there is one more point, I see that someone wrote a program that uses transaction processing, but he just:
begin transaction
.............
commit

Can he guarantee that the data operation will not go wrong? Why not judge?

prajna

Affairs have other purposes. . .

caboom04

Finally figured it out, thanks!

feiyun_1765

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?