|
Syntax: SAVE [TRANSACTION ][SavepointID]: Sql server accept TRAN here as option for TRANSACTION. SavepointID here is the user defined Savepoint it must be at most 32 characters: This command set a user define Savepoint within a transaction.
Ex: BEGIN TRANSACTION CreateEmployee
INSERT INTO EMPLOYEE (Empl_ID, FirstName, LastName, Department) VALUES (‘HR12054’,’Jeremie‘, ‘Yates’, ‘HR’)
SAVE TRANSACTION Benefits
INSERT INTO EMPL_Salaries (Empl_ID, Amount , Vacation ) VALUES (‘HR12054’,1750,3) INSERT INTO EMPL_Parking (Empl_ID, Days , Amount ) VALUES (‘HR12054’,5,600) INSERT INTO EMPL_Lunch (Empl_ID, Amount ) VALUES (‘HR12054’,450)
IF @@ERROR <> 0 BEGIN –Log error message ROLLBACK TRANSACTION Benefits END ELSE BEGIN –Log success message COMMIT TRANSACTION END
--END CreateEmployee
|