What is a Transaction in MSSQL SERVER
1644
28-Feb-2016
Updated on 23-Sep-2020
Anupam Mishra
28-Feb-2016Types of Transactions:
1. Implicit Transaction:Implicit transactions are maintained by SQL Server for each and every DDL (CREATE, ALTER, DROP, TRUNCATE), DML (INSERT, UPDATE, DELETE) statements.
2. Explicit Transaction: Explicit transactions are defined by programmers. In Explicit transaction we include the DML statements that need to be execute as a unit.