sql - 运行查询时遇到除以零错误

Question

下面是我尝试使用 Microsoft SQL Server Management Studio 运行的查询：

update [SG report MPD-4153] 
set [percent_paid] =  (try_convert(float, [Savings This Season])  * 100 / try_convert(float, [Savings 
Goal Amount]));

标签： sqlsql-serverssms

Answer 1

您可以nullif()在分母上使用：

update [SG report MPD-4153] 
    set [percent_paid] =  (try_convert(float, [Savings This Season])  * 100 
                           nullif(try_convert(float, [Savings Goal Amount], 0)
                          );