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_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() ...

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