Concurrency Control in SQL Server


A “Transaction” in SQL Server 

The standard definition of a transaction states that “every query that runs in a SQL Server is in a transaction,” that means any query you run on a SQL Server is considered as being in a transaction. It could either be a simple SELECT query or any UPDATE or ALTER query. 

If you run a query without mentioning the BEGIN TRAN keyword then it would be considered an implicit transition. If you run a query that starts with BEGIN TRAN and ends with COMMIT or ROLLBACK, then it would be considered an explicit transaction. Transaction