diTii.com Digital News Hub

Sign up with your email address to be the first to know about latest news and more.

I agree to have my personal information transfered to MailChimp (more information)


JSON Support Now Generally Available in Azure SQL Database

JSON support now generally available in Azure SQL Database, letting you query and store both relational and textual data formatted in JavaScript Object Notation (JSON) using Azure SQL Database.

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.

JSON support is generally available in Azure SQL Database

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.

If you’re new, “JSON in Azure SQL Database enables you to build and exchange data with modern web, mobile and HTM5/JavaScript single-page applications, NoSql stores such as Azure DocumentDB that contain data formatted as JSON, and to analyze logs and messages collected from different systems and services, writes Jovan Popovic, Azure SQL Database program manager.”

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:

Share This Story, Choose Your Platform!

Get Latest News

Subscribe to Digital News Hub

Get our daily newsletter about the latest news in the industry.
First Name
Last Name
Email address
Secure and Spam free...