sql查询字段是空的语句并且空值用0代替怎么写？

Question

sql查询字段是空的语句并且空值用0代替

Answer 1

select xx = 0 from table where xx is null

Answer 2

select iif(字段="",0,字段) as 字段 from table