>>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.
>
>You need to add keyword OUTPUT when calling this SP, e.g.
>
Thank you.
>>declare @Test char(5)
>>set @Test = ''
>>execute MyProc @Test
OUTPUT>>print @Test
"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