22,302
社区成员




--table a (bz char(1),bh varchar(20))
select * from a
--result:
bz bh
---- --------------------
NULL 085
247
0 122
(3 行受影响)
select ISNULL(bz,0) from a
--result:
----
0
0
(3 行受影响)
select isnull(col1,0) col1 from tb
select isnull(ziduan,0) ziduan
from tb
or
select coalesce(ziduan,0) ziduan
from tb
select isnull(cast(col1 as int),0) col1 from tb
select isnull(字段,0) as 字段
from tab
select isnull(col1,0) col1 from tb