如何处理触发器中的异常

CREATE TRIGGER trg_AfterInsert ON YourTable
AFTER INSERT
AS
BEGIN
    BEGIN TRY
        -- 触发器的业务逻辑
        IF EXISTS (SELECT * FROM inserted WHERE SomeColumn IS NULL)
            RAISERROR ('SomeColumn cannot be null.', 16, 1);
    END TRY
    BEGIN CATCH
        -- 异常处理逻辑
        DECLARE @ErrorMessage NVARCHAR(4000);
        DECLARE @ErrorSeverity INT;
        DECLARE @ErrorState INT;

        SELECT 
            @ErrorMessage = ERROR_MESSAGE(),
            @ErrorSeverity = ERROR_SEVERITY(),
            @ErrorState = ERROR_STATE();

        RAISERROR (@ErrorMessage, @ErrorSeverity, @ErrorState);
    END CATCH;
END;

DELIMITER $$
CREATE TRIGGER trg_AfterInsert AFTER INSERT ON YourTable
FOR EACH ROW
BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
    BEGIN
        -- 异常处理逻辑
        ROLLBACK;
        -- 可以在这里添加日志记录等操作
    END;

    -- 触发器的业务逻辑
    IF NEW.SomeColumn IS NULL THEN
        SIGNAL SQLSTATE '45000'
        SET MESSAGE_TEXT = 'SomeColumn cannot be null.';
    END IF;
END$$
DELIMITER ;