BEGIN TRY
begin tran --开启事务
insert into xx
commit transaction --提交事务,执行sql
end try
begin catch
rollback transaction-- 回滚事务
end catch
BEGIN TRY
begin tran --开启事务
insert into xx
commit transaction --提交事务,执行sql
end try
begin catch
rollback transaction-- 回滚事务
end catch