[!INCLUDE [sqlserver2016-asdb-asdbmi-asa-fabricse-fabricdw](../../includes/applies-to-version/sqlserver2016-asdb-asdbmi-asa-fabricse-fabricdw.md)] Use the functions ...

JSON_ARRAY() Evaluates a (possibly empty) list of values and returns a JSON array containing those values JSON_OBJECT() Evaluates a (possibly empty) list of key-value pairs and returns a JSON object ...

JavaScript Object Notation (JSON) is a lightweight, data interchange format widely used to store semi-structured and unstructured data, as well as interchange data with REST Web Services. MySQL ...