Use the functions described on the pages in this section to validate or change JSON text or to extract simple or complex values.
| 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. |
For more info about the built-in support for JSON in SQL Server see JSON Data (SQL Server).
Validate, Query, and Change JSON Data with Built-in Functions (SQL Server)
JSON Path Expressions (SQL Server)
JSON Data (SQL Server)