With this new JSON functionalities, you can also easily format data stored in Azure SQL Database as JSON and expose it to any modern service or application.
The integration also allow you to use JSON functions that enable you to extract value from “JSON text (JSON_VALUE), extract object from JSON (JSON_QUERY), update some value in JSON text (JSON_MODIFY), and verify that JSON text is properly formatted (ISJSON),” the team explained.
OPENJSON function enables you to convert JSON text into a table structure.
Finally, JSON functionalities also enable you to easily format results of any SQL query as JSON text using the FOR JSON clause.
To integrate JSON in your application, learn more at the Getting Started page. And, to learn about scenarios on how to integrate JSON in your application, watch the videos below: