sql json query 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;