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
You want to detect all columns with JSON data in a database.
An ISJSON() ...