如何在SQL存储过程中实现日志记录和错误报告？

CREATE TABLE LogTable (
    LogID INT IDENTITY(1,1) PRIMARY KEY,
    LogType NVARCHAR(50),
    LogContent NVARCHAR(MAX),
    CreateTime DATETIME DEFAULT GETDATE()
)

BEGIN TRY
    -- 存储过程的主要逻辑
END TRY
BEGIN CATCH
    -- 错误处理逻辑
END CATCH

BEGIN CATCH
    INSERT INTO LogTable (LogType, LogContent)
    VALUES ('Error', ERROR_MESSAGE())
END CATCH

INSERT INTO LogTable (LogType, LogContent)
VALUES ('Info', '存储过程开始执行')

CREATE PROCEDURE MyStoredProcedure
AS
BEGIN
    BEGIN TRY
        -- 存储过程的主要逻辑
        INSERT INTO LogTable (LogType, LogContent)
        VALUES ('Info', '存储过程开始执行')

        -- 在此处编写存储过程的主要逻辑

        INSERT INTO LogTable (LogType, LogContent)
        VALUES ('Info', '存储过程执行成功')
    END TRY
    BEGIN CATCH
        INSERT INTO LogTable (LogType, LogContent)
        VALUES ('Error', ERROR_MESSAGE())
    END CATCH
END