How to shield from a division by zero error!

resource

How to shield from a division by zero error!
Because the value of the expression is applied to the dynamic SQL (such as exec sp_executesql @ sql, N '@ va numeric (18,6) output', @ va output),
There is a division operation in the expression, and there may be a division by zero, and the program will exit. How can this mask the error?
Write 0 to the result to continue running?

我是杀人狂

Judging before the case when field = 0 then 0 else ...

fanfan1980

Doesn't seem to work

我是杀人狂

Then divide it into 2 checks. Where <> 0
Union all again.

vgf10002

Add a case when ... else ... end

michealhenry

Support upstairs!

恶魔右指

The dividend is 0
Define in the dividend (case when value = 0 then 1 else value end)

zzclark

At the beginning of the query, add
set ansy_warnings off
This will not interrupt the query error when divided by 0, but will return null for the field divided by 0

zzclark

sorry, yes
SET ansi_warnings OFF

wtyrambo

Add a judgment to the division operation: case when the divisor> 0 then the dividend / divider else 0 end