MS_SQLselect nullif(isnull(A,0)+isnull(B,0),0) as [Sum] from table1Oracle用 select case when nvl(A,0)+nvl(B,0)=0 then null else nvl(A,0)+nvl(B,0)end as [Sum] from table1以下为样例:_sql两个字段相加...
MS_SQLselect nullif(isnull(A,0)+isnull(B,0),0) as [Sum] from table1Oracle用 select case when nvl(A,0)+nvl(B,0)=0 then null else nvl(A,0)+nvl(B,0)end as [Sum] from table1以下为样例:_sql两个字段相加...