Division is used for one-step computing during database query. You need to determine whether the divisor is 0.
The isnull (check_expression, replacement_value) function is used at the beginning. An error is found. For details about how to use isnull, see
Http://hi.baidu.com/xieyangqiye/blog/item/c82dadd249a96e83a0ec9ca1.html
After searching
Http://topic.csdn.net/t/20020419/23/661742.html
I found a solution and thanked jameszht for providing the solution.
Update [table_name] Set [column_name_1] = isnull ([column_name_2]/nullif ([column_name_3], 0), 0)
If the value of [column_name_3] is 0, the value of the nullif ([column_name_3], 0) expression is null.
If the divisor is null, the division result is null, that is, the result of [column_name_2]/nullif ([column_name_3] is null.
Then, use the isnull () function to set the division result to 0 or another required value.