By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table users (id int, details nvarchar(max));
insert into users values (1,N'{"data" :
[ { "name" : "luke", "dob" : "12-10-90", "addr" : "sample1", },
{ "name" : "sam", "dob" : "12-10-88", "addr" : "sample2" }
]}');
1 rows affected
select
ID,
JSON_VALUE(DETAILS, '$.data[0].name') ,
JSON_VALUE(DETAILS, '$.data[0].dob') ,
JSON_VALUE(DETAILS, '$.data[0].addr')
from
users;
| ID | (No column name) | (No column name) | (No column name) |
|---|---|---|---|
| 1 | luke | 12-10-90 | sample1 |