Sql 数据库表查询 Json 列

select top 10 mrp,*  FROM shp_FcWei where id='XW-20241017090546-577-1-87'

select mrp, jt.wid as liaowid,jt.num, *  FROM shp_FcWei
CROSS APPLY OPENJSON(mrp) WITH (wid varchar(50), num decimal(18,2)) AS jt
where id='XW-20241017090546-577-1-87'