sum()的值为null，如何让它变成0

select sum(field1) as r from table1 r is null 如何让r变成0 select isnull(sum(field1),0) as r from table1 r 不在是null，而是0