SQL Server Get RETURN value from stored procedure in SQL

thtygnil 于 2023-11-16 发布在其他

关注(0)|答案(3)|浏览(124)

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 the former stored procedure and save it in a variable in the latter?

I couldn't find anything related. All questions are about fetching the 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

sql-server

来源：https://stackoverflow.com/questions/13605198/get-return-value-from-stored-procedure-in-sql

3条答案

按热度按时间

w8ntj3qf1#

This should work for you. Infact the one which you are thinking will also work:-

.......
 DECLARE @returnvalue INT

 EXEC @returnvalue = SP_One
 .....

赞(0）回复(0）举报 2023-11-16

sczxawaw2#

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

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

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

赞(0）回复(0）举报 2023-11-16

tuwxkamq3#

Assign after the EXEC token:

DECLARE @returnValue INT

EXEC @returnValue = SP_One

赞(0）回复(0）举报 2023-11-16

我来回答

SQL Server Get RETURN value from stored procedure in SQL

3条答案

相关问题

热门标签

最新问答