>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