SQL Server: Statements vs. Batches vs. Transactions vs. Connections
- by Sleepless
My question is simple: What are the differences / similarities / cardinalities between
Transactions
Batches
Connections
and
Statements
in SQL Server?
As far as I understand a connection is a single communications channel between a SQL Server instance and a client within which collections of statements grouped as batches are executed. A batch is either implicitly or explicitly mapped to one or several transactions. Is this correct?