SQL Server 2016 lets you treat JSON objects like rows in a table, allowing you to use data from ... Select * From OPENJSON (jsondata); By default, the resulting table has columns (called key, value ...

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 ...