A transaction in SQL Server is a consecutive gathering of explanations or queries to perform single or numerous undertakings in a data set. Every transaction might have single perused, compose, update, or delete tasks or a blend of this large number of tasks. Every transaction should happen two things in SQL Server:
- Either all alteration is effective when the transaction is committed.
- Or on the other hand, all alterations are scattered when the transaction is rollback.