在SQL中计算分母为0时出错，怎么办

[am2002cnfj]

表两个列，A和B，视图中三个列：A、B、C。其中C=A/B，如果B为0，那么C=0,怎么写这个视图的SQL

[zlp321002]

create view V_T
as
select A,B,C=case when B=0 then 0 else B/A End
from 表

[vivianfdlpw]

create view v
as
select A
,B
,(case when B=0 then 0 else A/B end) as 'C'
from 表

[ls_jingwen]

create table div
( a float,
b float)

insert into div
select 5,2 union all
select 3,0 union all
select 4,2 union all
select 3,1

create view v_div
as
select a,b,
case b
when 0 then 0
else a/b end as c
from div

select * from v_div
結果:
a b c
------------------------------- ------------------------------------------------
5.0 2.0 2.5
3.0 0.0 0.0
4.0 2.0 2.0
3.0 1.0 3.0

[ls_jingwen]

sorry 結果:
a b c
5.0 2.0 2.5
3.0 0.0 0.0
4.0 2.0 2.0
3.0 1.0 3.0

[iwl]

create view v
as
select A
,B
,(case when B=0 then 0 else A/B end) as 'C'
from 表