当前位置：网站首页>SQLSERVER 2008 parses data in Json format

SQLSERVER 2008 parses data in Json format

2022-08-10 05:10:00 【CSDN Q&A】

SQLSERVER 2008 parses Json format data

Json format: '[{"SN":001,"Name":Zhang Xiaoming,"CardNO":320326199711074812},{"SN":002,"Name":Wang Xiaoer,"CardNO":320500197110925064},{"SN":003,"Name":Lin Shuangshuang,"CardNO":310410198508025027},{"SN":004,"Name":Du Qiang,"CardNO":303500200008015012}]'

Required results
SN Name CardNO
001 Zhang Xiaoming 320326199711074812
002 Wang Xiaoer 320500197110925064
003 Lin Shuangshuang 310410198508025027
004 Du Qiang 303500200008

原网站

版权声明
本文为[CSDN Q&A]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/222/202208031326066492.html