USE AdventureWorks
GO

BEGIN TRAN
  UPDATE NewVendorContact 
  SET ContactTypeID = (SELECT ContactTypeID FROM Person.ContactType
						WHERE Name = 'Owner')
  WHERE VendorID = 15 

-------- Only execute up to this point in the first batch ----
--------------------------------------------------------------
-------- Next, start execution here ----------------------

  UPDATE NewVendor 
  SET ActiveFlag = 'False'
  WHERE VendorID = 15


-------- Only execute up to this point in the next batch ------
--------------------------------------------------------------
ROLLBACK Tran

COMMIT TRAN


