使用JSON_VALUE访问SQL Server 2016中的JSON数组

要从phoneNumbers获取全部信息：

DECLARE @json nvarchar(max)=    '{      "firstName": "John",      "lastName" : "doe",      "age"      : 26,      "address"  : {        "streetAddress": "naist street",        "city"         : "Nara",        "postalCode"   : "630-0192"      },      "phoneNumbers": [        {          "type"  : "iPhone",          "number": "0123-4567-8888"        },        {          "type"  : "home",          "number": "0123-4567-8910"        }      ]    }'    SELECt [Type], [Number]    FROM OPENJSON( @json, '$.phoneNumbers' )     WITH ([Type] NVARCHAr(25) '$.type', [Number] NVARCHAr(25) '$.number');