However, even without a JSON datatype, SQL Server 2016 still lets you query data stored in JSON format. I’ll look at that support in a later column (among other features, it provides a way to ...

JSON is the leading data interchange format for web applications and more. Here’s what you need to know about JavaScript Object Notation.

Typical code looks like this: Select * From OPENJSON (jsondata); By default, the resulting table has columns (called key, value and type) with one row in the table for each property in the object.