Get RETURN value from stored procedure in SQL

Question

I have a stored procedure where it ends with a RETURN value of 0 or 1.

I want to use this value in an IF statement in another stored procedure.

How can I get the return value of a previous stored procedure and store it in a variable in the last?

I could not find anything related. All questions relate to getting RETURN values ​​in C #.

I was thinking maybe something like this:

SP_Two

DECLARE @returnValue INT SET @returnValue = EXEC SP_One IF @returnValue = 1 BEGIN --do something END ELSE BEGIN --do something else END 

Answer 1

This should work for you. Infact the one you think will also work: -

  ....... DECLARE @returnvalue INT EXEC @returnvalue = SP_One ..... 

Answer 2

The accepted answer is invalid with a double EXEC (only the first EXEC is needed):

 DECLARE @returnvalue int; EXEC @returnvalue = SP_SomeProc PRINT @returnvalue 

And you still need to call PRINT (at least in Visual Studio).

Answer 3

Assign after EXEC token:

 DECLARE @returnValue INT EXEC @returnValue = SP_One