-- Syntax --

SAVE { TRAN | TRANSACTION } { savepoint_name | @savepoint_variable }

[ ; ]

-- Example 69 --

USE EBusiness

GO

CREATE TABLE Product_Master

(

Product_Code varchar(5) PRIMARY KEY,

Product_Name varchar(50) NOT NULL

)

GO

BEGIN TRANSACTION Product_Detail

INSERT INTO Product_Master VALUES ('P01','Product A')

INSERT INTO Product_Master VALUES ('P02','Product B')

INSERT INTO Product_Master VALUES ('P03','Product C')

INSERT INTO Product_Master VALUES ('P04','Product D')

INSERT INTO Product_Master VALUES ('P05','Product E')

SAVE TRANSACTION Product_List

INSERT INTO Product_Master VALUES ('P101','Product 101')

INSERT INTO Product_Master VALUES ('P102','Product 102')

INSERT INTO Product_Master VALUES ('P103','Product 103')

INSERT INTO Product_Master VALUES ('P104','Product 104')

INSERT INTO Product_Master VALUES ('P105','Product 105')

ROLLBACK TRANSACTION Product_List

COMMIT TRANSACTION Product_Detail

SELECT * FROM Product_Master