ACCESS中空值默认为0

select iif(isnull(sum(price)),0,sum(price)) from XX

posted @ 2012-01-13 16:24  北纬32  阅读(437)  评论(0)    收藏  举报