New answers tagged

5

You should directly extract the values from the json array using the WITH clause, like this: SELECT src.* , tt.* FROM json_test src CROSS APPLY OPENJSON(src.the_json , 'lax $') WITH ( [name] sysname '$.name' , [object_id] int '$.object_id' , [principal_id]...


Top 50 recent answers are included