What Are the Transaction in Sql Server

A transaction is a single unit of work. If a transaction is successful, all of the data modifications made during the transaction are committed and become a permanent part of the database. If a transaction encounters errors and must be canceled or rolled back, then all of the data modifications are erased.

What is SQL transaction example?

A transaction is the propagation of one or more changes to the database. For example, if you are creating a record or updating a record or deleting a record from the table, then you are performing a transaction on that table.

What are the types of transactions in SQL Server?

• BEGIN DISTRIBUTED TRANSACTION. ROLLBACK TRANSACTION.
• BEGIN TRANSACTION. ROLLBACK WORK.
• COMMIT TRANSACTION. SAVE TRANSACTION.
• COMMIT WORK.