C
cnaoszh
Unregistered / Unconfirmed
GUEST, unregistred user!
SELECT A.FA1,A.FA2,B.FB2+'0' as fb2-1 FROM A LEFT OUTER JOIN B ON FB1 = FA1
M
madm
Unregistered / Unconfirmed
GUEST, unregistred user!
cnaoszh的办法让我眼前一亮，但试完还是失望——不行
SELECT A.FA1,A.FA2,B.FB2+'0' as fb2-1 FROM A LEFT OUTER JOIN B ON FB1 = FA1
B.FB2为整形+'0'报错
但为null的B.FB2不管加任何数还是为null
iie的办法: ... where ...=Null
不能同时查出为null与不为null的纪录
SELECT A.FA1,A.FA2,B.FB2+'0' as fb2-1 FROM A LEFT OUTER JOIN B ON FB1 = FA1
B.FB2为整形+'0'报错
但为null的B.FB2不管加任何数还是为null
iie的办法: ... where ...=Null
不能同时查出为null与不为null的纪录
D
dragonh
Unregistered / Unconfirmed
GUEST, unregistred user!
function ISNULL(var A: Double): Double; cdecl; export;
implementation
function ISNULL(var A: Double): Double;
begin
result := A;
end;
这个绝对没问题 ！So Easy
implementation
function ISNULL(var A: Double): Double;
begin
result := A;
end;
这个绝对没问题 ！So Easy
M
madm
Unregistered / Unconfirmed
GUEST, unregistred user!
Think you.dragonh
问题竟然解决得如此简单 哎...
派分喽
问题竟然解决得如此简单 哎...
派分喽