SQL statements with zero division errors

This situation

Select * from a where c> 0 and (B/C)> 0.5 and (B/C) <0.6

In such a statement, because B and C are two numeric columns, the amount is recorded, and C may be 0, then although we add the condition C> 0, however, the error of division by zero may still occur.

There are two ways to solve this problem. One is to add a function and change C to 1 when C = 0; for example, B/checkdata (c) <0.6

Another method is to use the SQL server option to disable zero-Division Error interruptions and make it null.

SetAnsi_warningsOff
SetArithabortOff
SetArithignoreOn

Select * from a where c> 0 and (B/C)> 0.5 and (B/C) <0.6

If the value of 0 in a record is executed, the division of two numbers is null, and null <0.6 is invalid, as a condition.