11-13 C # Basics-Database transactions

Transaction

Definition: In the remote operation, have to go through two steps, first delete after inserting or first insert after delete, all to call two database, in order to ensure the integrity of the database, as long as the process of operation, as long as there is no success, automatic recovery, back to the beginning of the process. is actually a process control.

Role: In order to prevent errors in the process, reduce the work of the computer back and forth;

Equivalent to the Try...catch in the statement in VS.

Format:

BEGIN Tran

---statement----

If @ @error >0

Goto Tranrollback--tranrollback is a defined name

Begin

Tranrollback:

Rollback Tran

End

Else

Begin

Commit Tran

End

11-13 C # Basics-Database transactions