如何从SQL Server中的存储过程检索参数列表

SELECT SPECIFIC_CATALOG, SPECIFIC_SCHEMA, SPECIFIC_NAME, PARAMETER_NAME, ORDINAL_POSITION, PARAMETER_MODE, DATA_TYPE
FROM INFORMATION_SCHEMA.PARAMETERS
WHERE SPECIFIC_NAME = '存储过程名称'
ORDER BY SPECIFIC_CATALOG, SPECIFIC_SCHEMA, SPECIFIC_NAME, ORDINAL_POSITION;

SELECT OBJECT_SCHEMA_NAME(sp.object_id) AS 'SchemaName',
       OBJECT_NAME(sp.object_id) AS 'ProcedureName',
       p.name AS 'ParameterName',
       p.parameter_id AS 'ParameterID',
       t.name AS 'DataType',
       p.max_length AS 'MaxLength',
       p.precision AS 'Precision',
       p.scale AS 'Scale',
       p.is_output AS 'IsOutput'
FROM sys.procedures AS sp
JOIN sys.parameters AS p ON sp.object_id = p.object_id
JOIN sys.types AS t ON p.system_type_id = t.system_type_id AND p.user_type_id = t.user_type_id
WHERE OBJECT_NAME(sp.object_id) = '存储过程名称'
ORDER BY sp.name, p.parameter_id;