how to get stored procedure parameters list with name and datatype by query in sql server
  • i want to get list of parameters name and datatype which is using in stored procedure based on stored procedure name using query in sql server.
  • 1 Comment sorted by
  • you can use this query

    SELECT
    p.name AS Parameter,
    t.name AS [Type]
    FROM sys.procedures sp
    JOIN sys.parameters p
    ON sp.object_id = p.object_id
    JOIN sys.types t
    ON p.system_type_id = t.system_type_id
    WHERE sp.name = 'Your Stored Procedure Name'


Howdy, Stranger!

It looks like you're new here. If you want to get involved, or you want to Ask a new Question, Please Login or Create a new Account by Clicking below

Login with Facebook

Tagged

Popular Posts of the Week

Top Posters Weekly

Optimum Creative