Post reply

SP Columns

  • May 1, 2003 at 7:01 am

    #82163

    I am aware that there are a number of ways of finding out the params which need to be passed into an SP when it is called e.g. sp_procedure_params_rowset.

    However, is there any mechanism which I could use to get a list of the columns which are going to be returned in the resultset once the SP is executed?

  • May 1, 2003 at 7:21 am

    #455887

    Try something like this.

    select b.* from syscomments a, syscolumns b where

    a.id = object_id('YourStoredProcName) and a.id = b.id

    Darren


    Darren

  • May 1, 2003 at 7:23 am

    #455888

    Thanks, but that only returns a list of the SP Parameters (twice) and not the columns in the resultset.

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

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