SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE error_log (error_desc varchar(100))
INSERT error_log DEFAULT VALUES;
1 rows affected

CREATE PROCEDURE MyPROC
AS
BEGIN
    BEGIN TRY
        SELECT 1/0
    END TRY
    BEGIN CATCH
        UPDATE error_log SET error_desc='test'
    END CATCH
END
EXEC MyProc;
PRINT @@TRANCOUNT;


(No column name)


SELECT * FROM error_log;
UPDATE error_log SET error_desc = NULL;


error_desc


test


SET IMPLICIT_TRANSACTIONS ON;
EXEC MyProc;
PRINT @@TRANCOUNT;
IF @@TRANCOUNT > 0 ROLLBACK;


(No column name)


SELECT * FROM error_log;
UPDATE error_log SET error_desc = NULL;


error_desc


null