SQL Server 2005 metadata search to get stored procedure parameters

Question

How do you get a list of the input parameters for a stored procedure using metadata in SQL Server 2005? I want to do a SELECt on it and then iterate through the variable names.

Answer 1

start here

select * from information_schema.PARAMETERS
where SPECIFIC_NAME = 'YourStoredProcedureName'
order by ORDINAL_POSITION

look for parameter_name, data_type, parameter_mode