Answers for "error handling in sql server stored procedure"

SQL
0

create stored procedure for error handling in msq server

// errror handeling in sql server
        
     CREATE PROC usp_divide(
    @a decimal,
    @b decimal,
    @c decimal output
) AS
BEGIN
    BEGIN TRY
        SET @c = @a / @b;
    END TRY
    BEGIN CATCH
        SELECT  
            ERROR_NUMBER() AS ErrorNumber  
            ,ERROR_SEVERITY() AS ErrorSeverity  
            ,ERROR_STATE() AS ErrorState  
            ,ERROR_PROCEDURE() AS ErrorProcedure  
            ,ERROR_LINE() AS ErrorLine  
            ,ERROR_MESSAGE() AS ErrorMessage;  
    END CATCH
END;
GO
Posted by: Guest on June-23-2020

Code answers related to "error handling in sql server stored procedure"

Code answers related to "SQL"

Browse Popular Code Answers by Language