soumyagt
Old Hand
Points: 383
More actions
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?
Bhushan
Default port
Points: 1427
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