English (UK)

Visite: 1742

T-SQL Transaction 

/* 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

 

Argomenti Articoli