Here is the JSON string
DECLARE @jsonInfo VARCHAR(MAX)
SET @jsonInfo = N'{
"info":{
"type":1,
"address":{
"town":"Hyd",
"state":"TS"
"country": "India"
},
"tags":["sport", "Water Polo"]
},
"type":"Basic"
}'

what is the output of below query ?
JSON_QUERY(jsonString, '$.info.address.town')

 Posted by Bandi on 8/29/2017 | Category: Sql Server Interview questions | Views: 4423 | Points: 40
Select from following answers:
  1. NULL
  2. N'{ "town":"Hyd" }'
  3. N'{"Hyd" }'
  4. Error
  5. All Above

Show Correct Answer


| Alert Moderator 

Comments or Responses

Login to post response