JSON Functions (Transact-SQL)

Applies to: yesSQL Server 2016 (13.x) and later YesAzure SQL Database YesAzure SQL Managed Instance yesAzure Synapse Analytics

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

See Also