--只能跟据自己的规则自己处理了! declare @i decimal(18,2),@j decimal(18,2),@count decimal(18,2) set @i=10 set @j=100 if @j=0 set @count=0 else set @count=@i/@j select @count
SELECT COL2/(CASE COL1 WHEN 0 THEN 1 ELSE COL1 END) As Result FROM your Table
没看清楚要求,不好意思 SELECT (CASE COL2 WHEN 0 THEN 0 ELSE COL1/COL2 END) As Result FROM your Table
a/0=0
declare @i decimal(18,2),@j decimal(18,2),@count decimal(18,2)
set @i=10
set @j=100
if @j=0
set @count=0
else
set @count=@i/@j
select @count
SELECT (CASE COL2 WHEN 0 THEN 0 ELSE COL1/COL2 END) As Result FROM your Table