SQL Stored Procedure

5 pts.
Tags:
SQL stored procedures
Is there a way to call a child stored procedure form a parent sp but then immediately stop the parent?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Stored procedures have return values. In the parent sp check for a successful return value and end it in an if statement.

You can use a technique like this to do this.
<pre>
CREATE PROCEDURE YourParentPRoc
AS
DECLARE @retValue INT

EXEC @retValue = YourChildProc
IF @retValue <> 0
return(0)

/*
More code goes after the return.
*/
END</pre>

This will run the child procedure and if the return value is not 0 it will stop the parent. Any code after the return does not get run if the @retValue <> 0 is true.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    You might want to explain further what you need to accomplish.
    68,405 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following