查詢非空記錄
方法一、sql="select * from table where id<>null "
方法二、sql="select * from table where len(id)>1"
方法二、select * from News where Newstype = "指定值" and newspic is not Null order by NewsID desc
查詢值為空的記錄 select * from News where Newstype = "指定值" and newspic is Null order by NewsID desc
其它的反之