JSON | Notes on SQL

Shredding JSON Nested Arrays

Steve Hall

February 5, 2018

Whilst reading up on SQL Server 2016 JSON functionality I have seen many examples of extracting data from a JSON array. However, I wanted to work out how to extract data from an array within an array – for example, an array of customer data where each customer has an array of order details.

Indexing JSON Data in SQL 2016

Steve Hall

no comments

August 18, 2017

Introduction SQL 2016 has introduced support for JSON data. The nature of JSON data means that an indexing strategy isn’t as obvious. This article details my initial work, testing various methods for accessing the JSON data.