set implicit_transactions on

stmt <<-- ORACLE automatically BEGINS a transaction
stmt
stmt
go

stmt
stmt
stmt
go

stmt
stmt
go

rollback tran

--------------------
stmt <<-- SQL Server THIS statement "auto-commit" transaction
stmt
stmt
go

begin tran  -- logical unit of work????
stmt
stmt		-- WHAT HAPPENS if - this statement fails due to a constraint violation...
			-- HOW is xact_abort set?
stmt
commit tran
go

stmt
stmt
go

rollback tran


---------------
begin tran t1  @@trancount 1
	stmt
	stmt
	begin tran t2 @@trancount 2
		stmt
		stmt
		If..... 
			rollback tran t2 --> ENTIRE trans and sets @@trancount 0


---------------
begin tran t1  @@trancount 1
	stmt
	stmt
	begin tran t2 @@trancount 2
		stmt
		stmt
		If..... 
			rollback tran 
		else
			commit tran @@trancount 1
If..... 
	rollback tran 
else
	commit tran 
