JSON (JavaScript Object Notation) is a simple format for exchanging data. It is self-descriptive, understandable in any language, and irrespective of language. It serves as an XML substitute. JSON is currently a popular data transfer standard.
The data that is returned by modern services is JSON text. SQL Server JSON is the need for data developers to return JSON in SQL. The built-in JSON support in the SQL server is distinct from the native JSON type.
Following is a list of scalar functions that provide support for JSON in SQL Server −
| Sr.No. | Function & Description |
|---|---|
| 1 | ISJSON Is used to check a string’s validity for JSON (JavaScript Object Notation) syntax. |
| 2 | JSON_OBJECT Is used to create JSON objects from the results of evaluating the SQL expressions of the arguments. |
| 3 | JSON_ARRAY It accepts an expression or a comma-separated list of expressions and returns a JSON array containing those values. |
| 4 | JSON_VALUE It accepts a JSON string and returns a scalar value. |
| 5 | JSON_QUERY Is used to extract data from a JSON object. |
| 6 | JSON_MODIFY Is used to change JSON data kept in a column of a SQL Server table. |
| 7 | JSON_PATH_EXISTS Is used to determine whether a particular JSON path is present within a JSON string. |