EXCEPTION HANDLING | SQL Tutorial and Query Example

Text copied!

EXCEPTION HANDLING

July 14, 2023, 1:55 p.m. under SQLSyntax
    • EXCEPTION HANDLING syntax in SQL
    BEGIN TRY
    -- SQL statements to be executed
    SELECT 1/0; -- Division by zero to trigger an error
END TRY
BEGIN CATCH
    -- Error handling code
    SELECT
        ERROR_NUMBER() AS ErrorNumber,
        ERROR_MESSAGE() AS ErrorMessage,
        ERROR_SEVERITY() AS ErrorSeverity,
        ERROR_STATE() AS ErrorState;
END CATCH

    « Previous
    Next »
    RELATED :