---????????
begin tran
--??????????????????????????е?????????????
begin try
--??????
insert into lives (Eat??Play??Numb) values ('????'??'????'??1)
--???????
save tran pigOneIn
--Numb?int?????????
insert into lives (Eat??Play??Numb) values ('????'??'????'??2)
--??????
insert into lives (Eat??Play??Numb) values ('????'??'????'??3)
end try
begin catch
select Error_number() as ErrorNumber??  --???????
Error_severity() as ErrorSeverity??  --???????????????С??10 try catch ??????
Error_state() as ErrorState ??  --????????
Error_Procedure() as ErrorProcedure ?? --????????洢????????????????
Error_line() as ErrorLine??  --??????????к?
Error_message() as ErrorMessage  --???????????
if(@@trancount>0) --??????@@trancount??????????+1?????????ж????п???????
rollback tran   ---????????????????????????????????в???????
end catch
if(@@trancount>0)
rollback tran pigOneIn --??????Lives???У???????3???????
--??????????ID ??Numb?int ??????????nvarchar????
select * from lives

???????set xact_abort
???????? xact_abort on/off ?? ????????????????on???????sql?????????????????off????sql?????????sql????????????????ж?д?????
??????????????xact_abort????????????????????????sql??????????????????????????

 

delete lives  --???????
set xact_abort off
begin tran
--??????
insert into lives (Eat??Play??Numb) values ('????'??'????'??1)
--Numb?int?????????????1234..????????????'132dsaf' xact_abort???Ч
insert into lives (Eat??Play??Numb) values ('????'??'????'??12345646879783213)
--??????
insert into lives (Eat??Play??Numb) values ('????'??'????'??3)
commit tran
select * from lives
?on???????????????????????????????????????????????
???????????????????
??????????????????????????????????????2????????????5????????2????????顣
begin tran
update lives set play='?????'
waitfor delay '0:0:5'
update dbo.Earth set Animal='???'
commit tran
begin tran
update Earth set Animal='???'
waitfor  delay '0:0:5' --???5?????????????
update lives set play='?????'
commit tran
select * from lives
select * from Earth

?????????????????????????????????
????????????????????——????
?????????????????????????????????????????￡????????????????????
???????????????????????????????????и??￡?????????????????????????????д????
??????????????????????????????????ж?ζ?????????????????????????????????????????????????????ζ???????????
???????????????????????????????????μ?????????????????????и?????????????????????????????????????1???????????1????????????????????????塣
??????????????????????????????????????????????????????????????????????????????ζ????????????в??????????????????????
?????????????????????Щ???????????????????????????????????????????в??????????????????????????????Щ????顣??????ν????????