database - Find the parameter names of a stored procedure

Question

I am using Microsoft SQL Server 2008. I have a stored procedure. Is there a simple query I can execute that will give me the parameter names?

I have found this Link but it is not for Microsoft SQL Server 2008.

Answer 1

To get names only you can use this query:

SELECT name
FROM sys.parameters
WHERE object_id = OBJECT_ID('YourProcedureName')

To get more detailed info (name, type and length of parameter):

SELECT p.name AS ParameterName, t.name AS ParameterType, p.max_length AS ParameterLength
FROM sys.parameters AS p
JOIN sys.types AS t ON t.user_type_id = p.user_type_id
WHERE object_id = OBJECT_ID('YourProcedureName')