SQL SERVER 2005 事务

USE AdventureWorksGOCREATE TABLE MyTranTest(OrderID INT PRIMARY KEY IDENTITY)BEGIN TRANSACTION TranStartINSERT INTO MyTranTestDEFAULT VALUESSAVE TRANSACTION FistPointINSERT INTO MyTranTestDEFAULT VALUESROLLBACK TRANSACTION FistPointINSERT INTO MyTranTestDEFAULT VALUESSAVE TRANSACTION SecondPointINSERT INTO MyTranTestDEFAULT VALUESROLLBACK TRANSACTION SecondPointINSERT INTO MyTranTestDEFAULT VALUESCOMMIT TRANSACTIONSELECT TOP 3 OrderIDFROM MyTranTestORDER BY OrderID DESCDROP TABLE MyTranTest