I have some query that outputs a JSON, i.e.,
select 1 AS 'test'
for json path, without_array_wrapper
After clicking on the result, which is {'test':1}, SSMS 18.10 opens a file with the JSON output. If I save this file as test.json, and attempt to load it elsewhere (either in an editor like Atom, in Python, etc), I get an error.
In comparison, if I copy the output and paste it into an empty test.json file, it works just fine.
What is going on here?
Asked by Rushabh Mehta
(251 rep)
Mar 1, 2022, 02:40 PM