Sometimes we require to know the details of all the parameters used in an SQL Server stored procedure. It's also important for the view of a programmer. Because, they need to pass the values with one to one relationship of parameters.
Below mentioned script helps you to list all the parameters of a stored procedure. Suppose we want to get all the parameters for the Store Procedure "usp_Submitproduct" then the below SQL script needs to be executed.
SELECT * FROM sys.parameters pm INNER JOIN Sys.Objects O ON O.object_id=pm.object_id WHERE pm.name='usp_Submitproduct'