Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to capture Returned value from Execute
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01544276
Message ID:
01544277
Views:
41
This message has been marked as the solution to the initial question of the thread.
IIRC
EXECUTE @RetVal = MyStoredProc Param1, Param2
>
>While testing a stored procedure I execute it in the SSMS query, something like this:
>
>
>EXECUTE MyStoredProc Param1, Param2
>
>
>The stored procedure MyStoredProc has RETURN 'somevalue' code at the end.
>
>How can I capture the returned values in the query? I tried the following:
>
>
>declare @RetVal as VarChar(20)
>@RetVal = EXECUTE MyStoredProc Param1, Param2
>
>
>but I get error. What else could I do?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform