Answers for "How to use wildcard in Jason_VALUE"

0

How to use wildcard in Jason_VALUE

select json_value(t.trans_msg, '$.CheckDetails[0].CheckNumber'), -- works returns 101
       json_value(t.trans_msg, '$.CheckDetails[*].CheckNumber'), -- null returned      
       json_value(t.trans_msg, '$.CheckDetails[0,1].CheckNumber') -- null returned      
 from transactions t
where t.id = 1
Posted by: Guest on November-03-2020
0

How to use wildcard in Jason_VALUE

SELECT JSON_VALUE(@json,'$.Dims[0].Name');
Posted by: Guest on November-03-2020

Code answers related to "Javascript"

Browse Popular Code Answers by Language