score:1

Accepted answer
SELECT Substring(Parameters.Name,2,255) + ': { type: DataType.' + 
       CASE types.Name
          WHEN 'varchar' THEN 'String(' + CAST(Parameters.Max_Length As Varchar)      
          WHEN 'int' THEN 'Int'
          ELSE 'COMPLETE THE REST OF THIS yourself.....'
       END + '),},'
FROM Sys.Parameters
INNER JOIN sys.procedures on parameters.object_id = procedures.object_id 
INNER JOIN sys.types on parameters.system_type_id = types.system_type_id AND parameters.user_type_id = types.user_type_id
Where procedures.name = 'MyStoredProcedureName'

score:0

{
  "InvoiceNo": {
    "type": "int"
  },
  "TransDate": {
    "type": "datetime"
  },
  ...
}

Related Query

More Query from same tag