O'Reilly logo

XML and JSON Recipes for SQL Server: A Problem-Solution Approach by Alex Grinberg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

©  Alex Grinberg 2018
Alex GrinbergXML and JSON Recipes for SQL Serverhttps://doi.org/10.1007/978-1-4842-3117-3_8

8. Constructing JSON

Alex Grinberg
(1)
Richboro, Pennsylvania, USA
 
Welcome to Part II of this book. Part II will cover JSON for SQL Server, which was introduced in SQL Server 2016. JSON has many similarities to XML; however, they are not the same. JSON can be thought of as a “fat-free” version of XML. To run the samples for Part II, make sure that the database compatibility level in SQL Server 2016 is set to 130. The sample database for Part II is WideWorldImporters. Please use the following link to download the database: https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0?utm_source=MyTechMantra.com ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required