With SQL Server 2016, it now makes sense to store JSON objects in your database (even though there’s no JSON datatype). Here’s how to query JSON properties to find the rows you want.

Native support for JSON in the upcoming SQL Server 2016 was buried among the many goodies announced earlier this month for the flagship RDBMS, but it's the feature most requested by data developers, ...

In SQL Server 2025 (and an upcoming update of Azure SQL), the JSON_VALUE () function will be improved to support a RETURNING clause, allowing specifying the data type coming out of the JSON property.