Post reply

Sql Function to get list of parameters and their types for a given stored proc.

  • July 27, 2006 at 9:38 am

    #114312

    By which sql function can I get list of parameters and their types for a given stored proc?

  • July 27, 2006 at 9:56 am

    #651925

    use information_schema.parameters view...

  • July 27, 2006 at 10:10 am

    #651932

    information_schema.aparametrs view helps but I would like to know a different database stored procs parameter list. Database name is variable as I give any database name. So I cannot use USE stmt.

     

  • July 27, 2006 at 10:45 am

    #651944

    then use <>.sys.all_parameters view

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

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