Identify input and output parameters in stored procedure

Question

If I have a stored procedure containing input and output parameters, is it possible to access this information some how? What I would like is a list identifying the parameters and whether they are input or output.

I just "discovered" sp_sproc_columns. Seems like it might be used. — Karsten Strøbæk
– Karsten Strøbæk, Commented Oct 11, 2011 at 7:36

Martin Smith · Accepted Answer · 2011-10-11 07:36:11Z

4

SELECT name, 
       is_output
FROM sys.parameters
WHERE object_id=object_id('dbo.YourProc')

answered Oct 11, 2011 at 7:36

Martin Smith

457k97 gold badges777 silver badges887 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Karsten Strøbæk Over a year ago

Thank you Martin. Your answer let me to the sp_sproc_columns SP which provided the information I required.

Damien_The_Unbeliever · Accepted Answer · 2011-10-11 07:37:47Z

0

sys.parameters is a table containing such information (e.g. the is_output column)

answered Oct 11, 2011 at 7:37

Damien_The_Unbeliever

241k28 gold badges358 silver badges470 bronze badges

Collectives™ on Stack Overflow

Identify input and output parameters in stored procedure

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related