ÇóÀàËÆsqlserverÖÐisnull()º¯ÊýÔÚaccessÖÐÈçºÎʵÏÖ

isnull(a,b)
¼´Èç¹ý×Ö¶ÎaΪnullÔò·µ»Øb
eg:
select isNUll(a,b) from table_1;

---

Ö±½Ó IFNULL¾ÍÐÐÁË¡£

SQL code:
mysql> select ifnull(null,2);
+----------------+
| ifnull(null,2) |
+----------------+
| 2 |
+----------------+
1 row in set (0.01 sec)

mysql> select ifnull(1,2);
+-------------+
| ifnull(1,2) |
+-------------+
| 1 |
+-------------+
1 row in set (0.00 sec)

mysql>

---

Â¥ÉÏ¿´´íÁË¡£ACCESSµÄ»°£¬Ôò¿ÉÒÔÓÃ1Â¥µÄ»òÕßÓà NZ()
select NZ(a,b)