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

©  Alex Grinberg 2018

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

9. Converting JSON to Row Sets

Alex Grinberg¹ 

(1)

Richboro, Pennsylvania, USA

 

In this chapter, we will discuss recipes demonstrating how to detect a JSON document, different ways to shred JSON, and how to improve performance when you want to filter a JSON document. SQL Server JSON integration provides comprehensive coverage to convert a JSON document into a scalar value and rows-columns set. You will find a variety of tested samples and possible scenarios to help you find the most appropriate solution for your task.

9-1. Detecting the Columns with JSON

Problem

You want to detect all columns with JSON data in a database.

Solution

An ISJSON() ...