Transactions group is a set of tasks into a single execution unit. Each transaction begins with a specific task and ends when all the task in the group successfully complete. If any of the tasks fails, the transaction fails.
Users can group two or more Transact-SQL statements into a single transaction using the following statements:
- Begin Transaction
- Rollback Transaction
- Commit Transaction