Hi @Ashish Singh
To format/export query results as JSON, use the FOR JSON clause with the PATH or AUTO mode.
Please refer to these two documents for more details:
Format Query Results as JSON with FOR JSON (SQL Server)
How to import/export JSON data using SQL Server 2016
Best regards,
LiHong
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.