>Hi,
>
>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?
Hi Dimitry
Right click on the sp in SSMS and select Script As . Execute . To query window.
that'll give you the correct syntax