This example selects particular name/value pairs from the JSON document using JSON string syntax. If a row does not have a specific name requested, null is returned.
select QueryID, RowNum, ParamJSON."Data Record" from QryLogParamJSON;
Result:
QueryID RowNum ParamJSON.Data Record ------------------ ------ --------------------- 307190733539634351 1 ? 307190733539634351 2 {"x":"10"}