SQL语句语法错
f10是数据表T_Invoice的一个字段.下列SQL语句有语法错:
select iif(f10 is null,0,5)
from T_Invoice
错在哪里?

[解决办法]
select case when f10 is null then 0 else 5 end
from T_Invoice