更新时间:2023-02-06 14:19:38
查看 tblBenchmarkData 的模式定义会很有帮助,但您可以尝试在查询中使用 ISNUMERIC.类似的东西:
It would be helpful to see the schema definition of tblBenchmarkData, but you could try using ISNUMERIC in your query. Something like:
SET DataValue = CASE WHEN ISNUMERIC(DataValue)=1 THEN CAST(DataValue AS float) * 1.335
ELSE 0 END