From the course: Microsoft SQL Server 2016 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Working with JSON

Working with JSON - SQL Server Tutorial

From the course: Microsoft SQL Server 2016 Essential Training

Start my 1-month free trial

Working with JSON

“

- [Narrator] In this section we're going to talk about working with JSON in SQL Server 2016. JSON is an acronym that stands for JavaScript Object Notation. Much like XML it is text based, human readable, and used for information exchange. JSON tends to be a little more compact than XML and tends to be growing in popularity because of that. However XML does have some more mature validation tools. Here's a sample of JSON. JSON is very much in the mindset of key value pairs. So in this case firstName would be a key then we have colon and the value John goes with the key of firstName. We then have a comma and the next key value pair. Key of lastName of value of Smith. Microsoft SQL Server 2016 has added some new features for working with JSON. The first one I'll demonstrate is having a query return JSON formatted results. So I'll again work with the WideWorldImporters database. I'm going to create a new query. And we use the same table as we used for the XML demos, the Application.People…

Contents