SqlServer try catch 捕获触发器存储过程异常,结合 transaction 事务

SoEasy~，贴上代码看所有

ALTER trigger [dbo].[tgr_SG_Gathering_update]
on [dbo].[SG_Gathering]
    for update --更新触发
as
    --定义变量
    declare @fMoney float,
    @fQuantity float,
    @vShop varchar(20),
    @vEmpCode varchar(20),
    @vSPosition varchar(20),
    @vSPCode varchar(20),
    @SetID int,
    @Amount float,
    @Coupon varchar(20),
    @RJ varchar(10),
    @DiscountNum int;

    begin try
        begin transaction
            if (update(bCancel)) --bCancel日结动作
                begin
                    --变量取值
                    select @RJ=bTotal,@fMoney=fMoney,@vShop=vShop,@vEmpCode=vEmpCode,@vSPCode=vSPCode,@fQuantity=fQuantity,@vSPosition=vSPosition 
                    from inserted;

                    INSERT INTO [NoahERP].dbo.DiscountCouponPool( SetID,Coupon,CardType,Type,PP,MadeType,Rate,Price,Amount,StartDate,EndDate,
                                CreateDate,UseDate,ModifyPerson,IsDel,ImgUrl,UsedImgUrl,OverImgUrl,ClothesCounts) 
                        SELECT  S.ID,@Coupon,S.CardType,S.[Type],S.[PP],S.MadeType,P.Rate,P.Price,S.Amount,S.StartDate,S.EndDate,
                                GETDATE(),NULL,'',0,P.ImgUrl,P.UsedImgUrl,P.OverImgUrl,S.ClothesCounts 
                                FROM [NoahERP].[dbo].[DiscountCouponSet] S 
                                left join  NoahERP.dbo.DiscountCouponPrice P on S.ID=P.SetID 
                                where  CONVERT(date, GETDATE()) >= CONVERT(date,S.StartDate) AND DATEADD(DAY,-1,CONVERT(DATE,GETDATE())) < CONVERT(date,S.EndDate)  
                                AND  S.IsStop = 0 And S.Type=1  AND S.ID=@SetID;
                end
        commit transaction    --提交事务
    end try
    begin catch

    if(@@TRANCOUNT>0)
        begin
            rollback transaction;--出现错误回滚
        end
    --记录错误信息到[SG_GatheringLog]表
    insert into [dbo].[SG_GatheringLog](ErrorNumber,
                                        ErrorSeverity,
                                        ErrorState,
                                        ErrorProcedure,
                                        ErrorLine,
                                        ErrorMessage)
    select ERROR_NUMBER()  ErrorNumber,            --返回导致运行 CATCH 块的错误消息的错误号
           ERROR_SEVERITY()  ErrorSeverity,        --返回导致 CATCH 块运行的错误消息的严重级别
           ERROR_STATE()  ErrorState,            --返回导致 CATCH 块运行的错误消息的状态号
           ERROR_PROCEDURE()  ErrorProcedure,    --返回出现错误的存储过程或触发器名称
           ERROR_LINE()  ErrorLine,                --返回发生错误的行号
           ERROR_MESSAGE()  ErrorMessage        --返回导致 CATCH 块运行的错误消息的完整文本
    end catch