Reputation: 653
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.
Upvotes: 2
Views: 444
Reputation: 239824
sys.parameters is a table containing such information (e.g. the is_output
column)
Upvotes: 0
Reputation: 454020
SELECT name,
is_output
FROM sys.parameters
WHERE object_id=object_id('dbo.YourProc')
Upvotes: 4