摘要： USE AdventureWorks;GOBEGIN TRANSACTION;GOUPDATE Person.Contact SET LastName = '1111' WHERE LastName = 'Wood';GOIF @@TRANCOUNT > 0BEGIN PRINT N'A transaction needs to be rolled back.'; ROLLBACK TRANSACTION;ENDselect LastName from Person.Contact WHERE LastName = 'Wood 阅读全文