Most people understand what a transaction is and how to set them up. The scope of this post is not to explain how transactions work within SQL Server, but for completeness sake I’ll provide a brief overview:
The basic premise is that SQL Server will run each statement as an implicit transaction unless the BEGIN TRANSACTION command [...]