Server JSON类型枚举

Question

给定的

declare @json varchar(max)='{
"name":"John",
"age":30,
"cars": [
    { "make":"Ford", "models":[ "Fiesta", "Focus", "Mustang","Vintage"] ,"price":[1100,200,300,999]},
    { "make":"BMW", "models":[ "320", "X3", "X5" ] },
    { "make":"Fiat", "models":[ "500", "Panda" ] }
] }';

查询

select * from openjson(@json,'$')

返回3列：

key value   type

我还没有找到类型列值及其对应意义的枚举。

请指出正确的方向，谢谢。

Answer 1

来自用于OPENJSON的MSDN页面：

Value of the Type column    JSON data type
0                           null
1                           string
2                           int
3                           true/false
4                           array
5                           object