SQL Server Save Transaction

Get ready:

CREATE TABLE Nums (X int);

Purpose: Inserts only one row into the table.

--------------------------------------------------------------------------------------------------------------- ----------------------

　　BEGIN TRANSACTION Tran_a-it is best to define a name for the transaction.

Insert into Nums (X) VALUES (9);

　　　　Save Transaction Save_tran; --Define a savepoint for a transaction, which can be rolled back to when the transaction is to be rolled back.

Insert into Nums (X) VALUES (4), (3), (2), (1);

　　　　ROLLBACK TRANSACTION save_tran;--ROLLBACK TRANSACTION to SavePoint

　　Commit TRANSACTION tran_a;--commits the transaction.
Go

　　

SQL Server Save Transaction