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.
Exercise 1: Relational composition to JSON format
Exercise 2: Querying JSON text
Exercise 3: OPENJSON function