Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Throw an Error on a procedure RE: Throw an Error on a procedure

  • February 6, 2018 at 10:05 pm

    #1978811

    Phil Parkin - Tuesday, February 6, 2018 9:03 AM

    Try something like this

    BEGIN TRY
        IF NOT EXISTS (
                SELECT 1
                FROM dbo.view_MyView
                WHERE MemberID = @MemberID
                )
        BEGIN
            THROW 50000
                ,'MemberId does not exist'
                ,1;
        END
    END TRY

    BEGIN CATCH
        THROW
    END CATCH

    Thank you Phil. How do I then return that "MemberID does not exist" back to users who calls my proc?