Post reply

List Columns Output by SP

  • June 17, 2004 at 10:15 am

    #108404

    How can I obtain a list of columns (and column properties) that are output by a stored procedure?

    I'm looking for something like sp_columns that will report on SP.

    TIA.

  • June 18, 2004 at 1:17 am

    #510962

    There is no way to determine which columns a stored procedure returns in SQL, since the output can have multiple record sets, my differ depending on parameters values, etc.

    By using ASP, PHP, etc. you can determine the amount of recordsets returned and their columns.

    For what purpose are you trying to return the columns a SP will output?

    ----------------------------------------
    Pascal Dobrautz
    www.sqlassi.net

Viewing 2 posts - 1 through 1 (of 1 total)

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