[MSSQL] 프로시저 파라미터 리스트, 개수

CREATE PROCEDURE sp_param
	@procedureName NVARCHAR(100)
AS
BEGIN

SELECT COUNT(*) AS ParameterCount
FROM sys.parameters
WHERE object_id = OBJECT_ID('dbo.' + @procedureName);

SELECT 
    p.name AS ParameterName,
    TYPE_NAME(p.user_type_id) AS DataType,
    p.max_length,
    p.is_output
FROM sys.parameters p
WHERE object_id = OBJECT_ID('dbo.' + @procedureName);

END