T-SQL事务实例

begin try  
     begin tran   
         insert into dbo.TransTestTable values (66,'66');   
         update dbo.TransTestTable set [Name] = '77' where [Id] = 66;   
         --RAISERROR ('Error raised in TRY block.',16,1);   
     commit tran   
end try  
begin catch  
     rollback tran   
end catch