SQL SERVER||How to overcome "Divide by zero error encountered" error?

Case Statement ISNULL with NULLIF Declare @denominator int =0 select 1/(case @denominator when 0 then 1 else @denominator end) AS Number declare @denominator int=0 select 1/isnull(nullif(@denominator,0),1) AS Number