>Yet another newbie question on stored procedure.
>
>I am trying to learn to get the OUTPUT parameter value.
>
>Here is simple stored proc:
>
>MyProc
> @Test char(5) = '' OUTPUT
>BEGIN
> set @Test = 'ABCD'
> RETURN
>END
>
>
>In a query window I do the following:
>
>declare @Test char(5)
>set @Test = ''
>execute MyProc @Test
>print @Test
>
>
>Why do I see empty value in @Test at the bottom?
>
>TIA.
declare @TestReturn char(5)
EXEC @TestReturn = myproc
Print @TestReturn