system tables

[sqlandsql]

How do you determine the parameter direction of a stored procedure parameter:

Input
Output
InputOutPut
ReturnValue

SELECT ParameterId = 0, ProviderRequestId = 0, sobj.NAME AS ProviderRequestCommandText, sparam.NAME AS ParameterName,
stype.NAME AS ParameterDataType, sparam.max_length AS ParameterLength, sparam.scale AS ParameterScale,
sparam.PRECISION AS ParameterPercision,
1 AS ParamterDirection, sparam.parameter_id AS ParameterOrder,
sparam.has_default_value AS ParameterDefault, sparam.default_value AS ParameterDefaultValue
FROM sys.objects sobj
JOIN sys.parameters sparam
ON sobj.OBJECT_ID = sparam.OBJECT_ID
JOIN sys.types stype
ON sparam.system_type_id = stype.system_type_id
WHERE sobj.TYPE = 'P' ORDER BY sobj.NAME, sparam.parameter_id

AND sparam.is_output = 1

[rmiao]

Check value of is_output column in sys.parameters.