Post reply

Equilivant to exit sub in a stored procedure?

  • March 24, 2006 at 3:36 am

    #167657

    Is there something simular to end sub, so if a stored procedure is run and a particular condition isn't met it won't continue with running the rest of the code, I've looked at QUIT() but can't seem to get it to work, any ideas anyone?

  • March 24, 2006 at 4:25 am

    #628545

    Mick,

    RETURN is what you are looking for.

    BOL shows an exmaple in a stored procedure.

    Cheers,

    Rodney.

  • March 24, 2006 at 4:32 am

    #628548

    that's exactly what I wanted, thank you Rodney

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply