SqlServer中的JsonTable

SELECT GYK.JsonTable from dbo.td_YWZC_Config_GYK_History AS GYK
[
　　{"检测对象":"试块型式","纵向缺陷检测1":"","纵向缺陷检测2":"","横向缺陷检测1":"","横向缺陷检测2":"","母材检测":""},
　　{"检测对象":"探头型号","纵向缺陷检测1":"","纵向缺陷检测2":"","横向缺陷检测1":"","横向缺陷检测2":"","母材检测":""},
　　{"检测对象":"探头移动区","纵向缺陷检测1":"","纵向缺陷检测2":"","横向缺陷检测1":"","横向缺陷检测2":"","母材检测":""},
　　{"检测对象":"检测灵敏度","纵向缺陷检测1":"","纵向缺陷检测2":"","横向缺陷检测1":"","横向缺陷检测2":"","母材检测":""},
　　{"检测对象":"灵敏度补偿","纵向缺陷检测1":"","纵向缺陷检测2":"","横向缺陷检测1":"","横向缺陷检测2":"","母材检测":""}
]

posted @ 2021-03-03 14:49  三生石头花  阅读(483)  评论(0)  编辑  收藏  举报