json value sql server code example
Example 1: jsonvalue sql
JSON_VALUE(jsonInfo,'$.info.address[0].town')
Example 2: json in sql server
SELECT name, surname
FROM emp
FOR JSON AUTO;
JSON_VALUE(jsonInfo,'$.info.address[0].town')
SELECT name, surname
FROM emp
FOR JSON AUTO;