Convert Dataset to json string in sql server

Question

Hi  How can i convert multiple select  statement to single json string? Thanks in advance.

Midhun T P · Answer

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

samanta · Answer

We cant do it in sql server?

Midhun T P · Answer

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