sql server 2016怎麽解析json

--1 帶 Root Key

select * from sys_menu for JSON AUTO ,ROOT('Result')

--2 as

select ID,

Name,

Age as [Entity.Age],

Sex as [Entity.Sex]

from Student for json path

-- 3 輸出有null列的 sql

select * from sys_menu for JSON AUTO ,ROOT('SUSU'), include_null_values

--4解析json --OPENJSON(將JSON文件轉換為普通數據表)