select isnull(fieldname,0) from tablename 如果字段fieldname的值是null,则结果是0 转载于:https://www.cnblogs.com/dekevin/p/4173705.html