I'm trying to extract the values, but the always return NULL.

```
DECLARE @TestTable TABLE
(
    JSON_Column NVARCHAR(MAX)
)

INSERT INTO @TestTable
VALUES
(
    (SELECT 111111 AS idTest1, 222222 AS idTest2 FOR JSON PATH)
);

SELECT 
    JSON_Column,
    JSON_VALUE(JSON_Column,'$.idTest1') AS idTest1,
    JSON_VALUE(JSON_Column,'$.idTest2') AS idTest2

FROM @TestTable

```

Results:

```
[{"idTest1":111111,"idTest2":222222}]   NULL    NULL

```

Expected:

```
[{"idTest1":111111,"idTest2":222222}]   111111  222222

```