
CREATE PROCEDURE sp_param @procedureName NVARCHAR(100)ASBEGINSELECT COUNT(*) AS ParameterCountFROM sys.parametersWHERE object_id = OBJECT_ID('dbo.' + @procedureName);SELECT p.name AS ParameterName, TYPE_NAME(p.user_type_id) AS DataType, p.max_length, p.is_outputFROM sys.parameters pWHERE object_id = OBJECT_ID('dbo.' + @procedureName);END