JSON Functions (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Use the following functions to validate or change JSON text or to extract simple or complex values.

For more info about the built-in support for JSON in SQL Server, see JSON Data (SQL Server).

Function Description
ISJSON Tests whether a string contains valid JSON.
JSON_VALUE Extracts a scalar value from a JSON string.
JSON_QUERY Extracts an object or an array from a JSON string.
JSON_MODIFY Updates the value of a property in a JSON string and returns the updated JSON string.

See Also

Validate, Query, and Change JSON Data with Built-in Functions (SQL Server)
JSON Path Expressions (SQL Server)
JSON Data (SQL Server)