Getting params in stored procedure

• Allan P. Lalisan

  Grasshopper

  Points: 12

  More actions

  January 10, 2007 at 10:36 pm

  #117058

  Hi guys!

  Is there a way to get the parameters and the corresponding data types of each parameter from a stored procedure using a T-SQL command without returning the entire text?

  Any help would be highly appreciated 🙂

  Thanks,

  Al

   

   

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  January 11, 2007 at 12:04 am

  #682614

  use the information_schema.parameters view.

  "Keep Trying"

• jezemine

  SSCrazy Eights

  Points: 8059

  More actions

  January 11, 2007 at 12:05 am

  #682615

  select * from INFORMATION_SCHEMA.PARAMETERS

  ---------------------------------------
  elsasoft.org

• Allan P. Lalisan

  Grasshopper

  Points: 12

  More actions

  January 11, 2007 at 12:13 am

  #682617

  Thanks guys!