Which Path parameter in the below JSON code snippet would NOT result in an error when used by JSON_VALUE in strict mode?

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

 Posted by Bandi on 8/29/2017 | Category: Sql Server Interview questions | Views: 1042 | Points: 40
Select from following answers:
  1. $.info.address.town
  2. $.info."address"
  3. $
  4. $.info.type[0]
  5. All Above

Show Correct Answer


| Alert Moderator 

Comments or Responses

Login to post response