Begin Transaction

Best Practice

BEGIN TRAN marks the beginning of a local transaction and is not recorded until T-SQL Commit (Private). This allows us to T-SQL Rollback any unwanted transactions.

Best practice is to use T-SQL Begin Transaction (Private) to start especially when using the following T-SQL Data Manipulation Language (Private) commands: INSERT, DELETE, & UPDATE

BEGIN TRAN
	INSERT INTO Database.Schema.Table (<field>)
	VALUES('<INSERTED VALUE>')
	
	SELECT *
	FROM Database.Schema.Table
ROLLBACK
COMMIT

---

Backlinks

• Transaction Control Language (DevLog)
• Update (DevLog)
• Commit (DevLog)
• Rollback (DevLog)