操作数数据类型varchar（max）对于除法运算符无效

由 Tim发布于 2020-05-18 03:53:11

以下是尝试使用Microsoft Server Server Studio运行的查询：

update [SG report] 
set [percentage_paid] =  ([Savings This Season (All)] / [Savings Goal Amount]) * 100

赫连迎蓉

2020-05-18 03:53:11

One or both of your values are strings. Use try_convert() to convert them to an appropriate type. The specific type is not clear, but something like:

update [SG report] 
    set [percentage_paid] =  (try_convert(float, [Savings This Season (All)])  * 100 /
                              try_convert(float, [Savings Goal Amount])
                             );

uet

2020-05-18 03:53:11

update [SG report] 
set [percentage_paid] =  ([Savings This Season (All)] / [Savings Goal Amount]) * 100
where isnumeric([Savings This Season (All)])=1 and isnumeric([Savings Goal Amount])=1

Tim

这家伙很懒，什么都没留下

积分
0
话题
0
评论
3131
注册排名
2617