JSON_VALUE Function in SQL Server 2016 — dotnetvibes


SQL Server 2016 provides built-in support for storing, managing and parsing JSON data. Sometimes you might need to just extract one scalar value from the JSON data, instead of parsing and returning the entire data. In such cases, you can effectively use a new function in SQL Server 2016 called JSON_VALUE().

via JSON_VALUE Function in SQL Server 2016 — dotnetvibes

Advertisements