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
Check this link for more detail
  Modified On Sep-18-2014 01:23:54 PM

Leave Comment