>>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
Your code gets the value returned from MyProce into variable @TestReturn. But stored procedure can only return a integer type. And it is not the parameter OUTPUT. So this does not work. But thanks for the suggestion.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham