declare @transtarted   bit
set @transtarted = 0
if( @@trancount = 0 ) -- 用于嵌套
begin
begin transaction
set @transtarted = 1
end
else
set @transtarted = 0
.....
if( @transtarted = 1 )
begin
set @transtarted = 0
commit transaction
end