exit from a stored procedure

Question

i hv some loop and a condition..if codition is match then i want to stop or exit from the stored procedure..how to do that?

while @@fetch_status=0
    begin
        if x=0
            'exit stored procedure
    end

Answer 1

if you are using Microsoft Sql Server than you can use Return Statement

while @@fetch_status=0 begin if x=0 return; end

Answer 2

By @@fetch_status it looks like your inside a cursor loop so I would not return at that point as you will skip tidying up after yourself.

...
if x=0
  GOTO DONE
...
/* at the end of the sp */
DONE:
  CLOSE @your_cur
  DEALLOCATE @your_cur