请教:一条sql的查询语句 SELECT *FROM table1WHERE (showpic IS NOT NULL) AND (DATENAME([year], indate) = '2005') and showpic is null 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SELECT *FROM table1WHERE (showpic IS NOT NULL) AND (DATENAME([year], indate) = '2005') and showpic is not null SELECT *FROM table1WHERE (showpic IS NOT NULL) AND (DATENAME([year], indate) = '2005') and isnull(showpic,'')<>'' SELECT *FROM table1WHERE (showpic IS NOT NULL) AND (DATENAME([year], indate) = '2005') and isnull(showpic,'')<>'' ... and (datalength(showpic)!=0 and datalength(showpic) is not null) 请我的查询哪里有问题?老提示错误.用星号代替列名就没问题. 在线等待!!万分火急!怎么样取出最后一个月份的那些数据啊??分不够再加! 请问这个简单的sql怎么有问题? 还是三表联合查询的问题 OLEDB provider 'Microsoft.Jet.OLEDB.4.0' reported an error是什么原因引起的 如何选择规定数量的记录 SQL 左连接的条数 如何查看历史状态数据 question!!! imp的问题如下.怎么搞定? 求sql语句--本人苦思两年未果 如何将dts包的结构化存储文件通过语句的转化为数据库存储模式啊!
FROM table1
WHERE (showpic IS NOT NULL) AND (DATENAME([year], indate) = '2005') and showpic is not null
FROM table1
WHERE (showpic IS NOT NULL)
AND (DATENAME([year], indate) = '2005')
and isnull(showpic,'')<>''
FROM table1
WHERE (showpic IS NOT NULL) AND (DATENAME([year], indate) = '2005') and isnull(showpic,'')<>''