JSON_expr.Combine ( JSON_expr [, { 'ARRAY' | 'OBJECT' } ] )
Syntax Elements
- JSON_expr
- An expression that evaluates to a JSON data type. For example, this can be a column in a table, a constant, or the result of a function or method.
- 'ARRAY' or 'OBJECT'
- Optional. Explicitly specifies the result type as 'ARRAY' or 'OBJECT'.
- If 'ARRAY' is specified, the result is a JSON document structured as an array. If 'OBJECT' is specified, the result is a JSON document structured as an object.
- When specifying 'OBJECT', both of the JSON documents being combined must be JSON objects; otherwise, an error is reported.