Get List of all parameters of an SQL Server Store Procedure

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'
Ebook Download
View all
Learn
View all