56,687
社区成员
发帖
与我相关
我的任务
分享
[{"fCategoryId":"796","fCondition":"0.8"},{"fCategoryId":"730","fCondition":"0.05"},{"fCategoryId":"731","fCondition":"0.05"}]
select CONVERT(json_extract('{"fCategoryId":"796","fCondition":"0.8"}','$.fCondition'),DECIMAL(5,2)) AS fcid;
<jrt>
<item>
<fCategoryId>1006</fCategoryId>
<fCondition>0.40</fCondition>
</item>
<item>
<fCategoryId>1007</fCategoryId>
<fCondition>0.30</fCondition>
</item>
<item>
<fCategoryId>1008</fCategoryId>
<fCondition>0.30</fCondition>
</item>
</jrt>
SET @xmlstring = '<jrt><item><fCategoryId>1006</fCategoryId><fCondition>0.40</fCondition></item><item><fCategoryId>1007</fCategoryId><fCondition>0.30</fCondition></item><item><fCategoryId>1008</fCategoryId><fCondition>0.30</fCondition></item></jrt>'
;
SELECT ExtractValue(@xmlstring, '/jrt/item/fCategoryId') as fCategoryId,ExtractValue(@xmlstring, '/jrt/item/fCondition') as fCondition;