-
system tables
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
-
Check value of is_output column in sys.parameters.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|