"Mike Thomas" <mike@ease.com> wrote in message
news:eQ5H4fPIFHA.2640@TK2MSFTNGP09.phx.gbl...
> OK, I'm a total greenhorn.
>
> In SQL Server 2000 Dev I have a stored proc which returns its value via an
> output parameter.
>
> In Query Analyzer, how can I 'see' this value? When I execute the proc,
the
> print window says the proc ran correctly, but I don't see the value of the
> output parameter.
>
> How can I get the window to display the value of the parameter?
>
> Many thanks
> Mike Thomas
>
>

"Adam Machanic" <amachanic@hotmail._removetoemail_.com> wrote in message
news:%23KUs8sPIFHA.2284@TK2MSFTNGP10.phx.gbl...
> DECLARE @OutputVal DATATYPE
>
> EXEC YourStoredProcedure @OutputVal OUTPUT
>
> PRINT @OutputVal
>
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
>
> "Mike Thomas" <mike@ease.com> wrote in message
> news:eQ5H4fPIFHA.2640@TK2MSFTNGP09.phx.gbl...
>> OK, I'm a total greenhorn.
>>
>> In SQL Server 2000 Dev I have a stored proc which returns its value via
>> an
>> output parameter.
>>
>> In Query Analyzer, how can I 'see' this value? When I execute the proc,
> the
>> print window says the proc ran correctly, but I don't see the value of
>> the
>> output parameter.
>>
>> How can I get the window to display the value of the parameter?
>>
>> Many thanks
>> Mike Thomas
>>
>>
>
>