Pull to refresh
  • by relevance
  • by date
  • by rating

SQL Server & Concurrency Control


What is a Transaction?

The standard definition of Transaction state that “Every Query batch that runs in a SQL server is a Transaction.”, this means any query you run on a SQL server will be considered as 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 as an Implicit transition.

If you run a query which starts with BEGIN TRAN and ends with COMMIT or ROLLBACK then it would be considered as Explicit Transaction.

Read more →
Total votes 2: ↑1 and ↓1 0
Views 1.1K
Comments 0