æ¨å¥½ï¼ææ³è¦sqlè¯å¥ï¼ä¸è¦ç¼ç¨è¯è¨ã
追çè¿ä¸é¢å°±æ¯æ¬èº«å°±æ¯SQL
æè
select isnull(imgValue ,null) hasImageValue from table where rsID=yourID,è¿æ ·ååºæ¥ä¸ºnull就表示没æå¼ï¼å¦å¼ æå¾ç
å¦æ ä½ æ¯æ°çæ¬çSQLserver,æ¯æIIFçè¯,å¯ä½¿ç¨ä¸é¢çè¯å¥
select iif(imgValue is null) hasImageVal from table where rsID=yourID