Post reply

Stupid Newbie Question about SQL Query Anylizer

  • June 13, 2005 at 11:05 am

    #69108

    How do you get output to the message window?

    I run this:

    execute TrendPeakTotal '11', '2000-01-01', '2005-06-13'

    which invokes a stored procedure which returns an output variable so how do I see this for testing purposes?

    Can I use a Print statment of some sort?

  • June 13, 2005 at 11:23 am

    #565071

    Declare @Output as datetime

    set @Output = '2005-06-13'

    exec TrendPeakTotal '11', '2000-01-01', @Output output

    Select @Output

  • June 13, 2005 at 1:49 pm

    #565105

    SELECT @Output will return a recordset

    You want to do everything that Remi said to do but instead:

    Print @Output



    A.J.
    DBA with an attitude

  • June 13, 2005 at 1:58 pm

    #565109

    Question about >>>> SQL Query Anylizer

    nothing about a command object that would make me think it's about the apllication call of the parameter.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply