ACCESS¶ÁÈ¡²»Îª¿ÕµÄ×ֶΠ- MS-SQL Server / ÒÉÄÑÎÊÌâ

ÈçÌâ.Ôõô¶ÁÈ¡Êý¾Ý¿âÖÐ×ֶβ»Îª¿ÕµÄÐÅÏ¢?

ÎÒÏë¶ÁÈ¡Êý¾Ý¿âÖÐͼƬһÀ¸²»Îª¿ÕµÄ¼Ç¼


SQL="select * from info where img not isnull"


ûÓб¨´í.µ«ÊÇËü°ÑËùÓеĶ¼¶Á³öÀ´ÁË.ûÓÐͼƬµÄÒ²¶Á³öÀ´ÁË..

---

SQL code:
select * from info where img is not isnull

---

SQL code:
select * from info where img is not null

---

SQL code:
SQL="select * from info where img is not isnull"

---

SQL code:
--access²»ÖªµÀÐв»試ÏÂ
SQL="select * from info where isnull(img,'')<>''"

---

SQL code:
select * from info where img is not null

---

SQL code:
SQL="select * from info where img is not null"
²»ºÃÒâ˼£¬ÒÔΪ¥Ö÷²î¸öIS

---

select * from info where img is not null

---

select * from info wher