T-SQL Transaction

Print
/* Quick Transaction */
BEGIN TRAN
 UPDATE myTable SET myField = 'Test' WHERE myId = 1
ROLLBACK TRAN
COMMIT TRAN

/* Extended Transaction */
BEGIN TRANSACTION CandidateDelete
GO
USE AdventureWorks2008R2
GO
UPDATE myTable SET myField = 'Test' WHERE myId = 1
GO
COMMIT TRANSACTION CandidateDelete
GO
ROLLBACK TRANSACTION CandidateDelete
GO

 

This website uses cookies to ensure you get the best experience on our website.