JSON_ARRAY

The following example returns rows in which the column

contains valid JSON.

The following example returns rows in which the column

contains valid JSON

SCALAR value at top level.

The following example returns 1 since the input is a valid JSON value -

true.

The following example returns 0 since the input is an invalid JSON value.

The following example returns 1 since the input is a valid JSON scalar according to RFC 8259.

JSON data in SQL Server

nvarchar(max)

json

json_col

json_col

SELECT id
, json_col
FROM tab1
WHERE
ISJSON(json_col) = 1

SELECT id
, json_col
FROM tab1
WHERE
ISJSON(json_col, SCALAR) = 1

SELECT
ISJSON(
'true'
,
VALUE
)

SELECT
ISJSON(
'test string'
,
VALUE
)

SELECT
ISJSON(
'"test string"'
, SCALAR)