JSON is a short form of Java Script Object Notation which is a simple and lightweight format for exchanging data between multiple sources. The main advantage of using JSON is, it is easy to read. SQL Server 2016 empowers us to work with JSON text. In this lab, we will learn to work with JSON text format and its supporting functions. In the first exercise, we will learn to convert relational composition to JSON text using FOR JSON clause. In the second exercise, we will learn to query the JSON text using JSON_QUERY, JSON_VALUE and JSON_MODIFY functions. In the third and final exercise, we will learn about OPENJSON function to retrieve data into relational format from JSON query.

Subscribe to Download


Version1.0
Download0
File Size900.12 KB
Create DateFebruary 7, 2017
Last UpdatedFebruary 7, 2017
SQL Server Advanced Aggregations
Query Store, Live Query Statistics and Live Query Plans