Convert Dataset to json string in sql server

Hi,

 

I'm not sure if this works perfectely or meets your need of converting multiple select statements to single json string. Still you can give it a try at the methods of below links -

 

https://gist.github.com/mcauser/5250601

 

https://www.sqlshack.com/convert-sql-server-results-json/

 

https://www.codeproject.com/Articles/815371/Data-Parsing-SQL-to-JSON 

Hi,

 

If you can do it in code level using c#, then please refer below blog -

 

http://www.dotnetlearners.com/blogs/view/250/convert-dataset-to-json---c--extension-method-example.aspx