I am using MS SQL 2012. Is there a way to get results in a JSON format from a recordset and use them to pass them as a string to post to an URL ?
For example a simple query
SELECT FirstNm, LastNm, email
So it returns:
Is this posible from SQL or do I need to do this afterwards in ASP. I am using ASP Classic.