Whenever I execute the stored procedure defined in a Microsoft SQL database using TypeORM as shown below:
const result=await conn.query('exec Spname @0,@1',[inp1val,inp2val]);
I receive a response from the database, but it comes with an additional prefix like this:
{'JSON_F52E2B61_18A1_11d1_B105_00805F49916B':'[{'name':'myname','age':10}]}
Why is the database result coming with that JSON prefix? How can I remove this prefix and only display the JSON object like this:
{'name':'myname','age':10}