BEGIN
begin tran
begin try
这里写入业务代码
if(@@ERROR=0)
commit tran
else
rollback tran
end try
begin catch
rollback tran
end catch
END
BEGIN
begin tran
begin try
这里写入业务代码
if(@@ERROR=0)
commit tran
else
rollback tran
end try
begin catch
rollback tran
end catch
END