SQL Server Transactions

 Transaction Property
1-Atomicity

2- Consistency
3- Isolation

4- Durable

Transaction Modes-
1- AutoCommit Transaction
2- Implicit  

SET IMPLICIT_TRANSACTIONS ON

3- explicit 

BEGIN TRAN

ROLLBACK TRANSACTION

COMMIT TRAN