I know that by using JSON Path and JSON Auto I can create an output in JSON in Microsof SQL. But what if I want to write this JSON output in a file? I have researched it on internet and haven't found any solution for this problem. Kindly help.
2
-
I wrote a Python script processing tool that will do this: pypi.python.org/pypi/execsql. Your script needs to be run from the OS so this is not strictly "in" Microsoft SQL.rd_nielsen– rd_nielsen2017-06-16 18:04:38 +00:00Commented Jun 16, 2017 at 18:04
-
What about BCP: stackoverflow.com/a/27153273/1662973Anthony Horne– Anthony Horne2017-06-16 18:18:22 +00:00Commented Jun 16, 2017 at 18:18
Add a comment
|