Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 how can i abruptly exit a stored procedure?

Author  Topic 

SQLIsTheDevil
Posting Yak Master

177 Posts

Posted - 2009-05-08 : 11:20:00
Hello,

How can I abruptly exit a storec proc? Is there a call similar to return?

Thank you!

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-05-08 : 11:22:40
It IS called RETURN

CREATE PROC ...
AS

...

IF @Something is True
RETURN

...

SELECT...



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

SQLIsTheDevil
Posting Yak Master

177 Posts

Posted - 2009-05-08 : 11:34:49
That works! Thank you very much.
Go to Top of Page

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2009-05-08 : 12:06:44
Unplug the server.

________________________________________________
If it is not practically useful, then it is practically useless.
________________________________________________
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-05-08 : 13:53:44
unplugged sessions are popular but in this case practically useless


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2009-05-08 : 14:23:26
Don't blame me. My solution satisfied the specified business requirements.


________________________________________________
If it is not practically useful, then it is practically useless.
________________________________________________
Go to Top of Page
   

- Advertisement -