Good Day,

You can use the "BEGIN TRAN" and "COMMIT TRAN" OR if you need to rollback then just use "ROLLBACK"

BEGIN TRANSACTION @TranName;

GO

USE AdventureWorks;

GO

DELETE FROM AdventureWorks.HumanResources.JobCandidate

WHERE JobCandidateID = 13;

GO

COMMIT TRANSACTION MyTransaction;

GO

The Rollback syntax

ROLLBACK { TRAN | TRANSACTION }

[ transaction_name | @tran_name_variable

| savepoint_name | @savepoint_variable ]

[ ; ]

Hope this helps you

regards

Stephen