3.2w+
社区成员
- 主页
- 基础类
- 应用实例
- 新技术前沿
晕，刚才的“”与NULL问题没解决，大家继续来讨论
我的意思是这样的：
写一查询语句，但要TYPE字段的值不等于“”，也不为NULL
我是这样写的
select * from table where type is not null and type is not ""
是错的，大家来指导
写一查询语句，但要TYPE字段的值不等于“”，也不为NULL
我是这样写的
select * from table where type is not null and type is not ""
是错的，大家来指导
...全文
请发表友善的回复…
发表回复
zhouchunyu 2008-01-16
select * from table where type is not null and type<>''这样就不会出错,注意type<>''这个是单引号
kk19840210 2008-01-16
不好意识更正下
select * from table where isnull(type,'')<>''
一样可以用到索引
select * from table where isnull(type,'')<>''
一样可以用到索引
yan9299 2008-01-16
谢谢大家，问题解决
kk19840210 2008-01-16
select * from table where type is not null and type <> ''
--可以用到索引
select * from table where isnull(type,'')<>'' --使用不到索引
dawugui 2008-01-16
select * from table where type is not null and type <> '' kk19840210 2008-01-16
select * from table where isnull(type,'')<>'' utpcb 2008-01-16
select *
from table
where type is not null and type<>''
简单
from table
where type is not null and type<>''
简单
areswang 2008-01-16
不好意思，1楼应是
select * from table where isnull(type,'') <> ''
select * from table where isnull(type,'') <> ''
sunhonglei2004 2008-01-16
没有看明白楼主的意思
select * from table where type='' and type is not null ??/
select * from table where type='' and type is not null ??/
-狙击手- 2008-01-16
select *
from table
where isnull(type,'') <> ''月下之木 2008-01-16
select * from table where type is not null and type != ""
-狙击手- 2008-01-16
select *
from table
where type is not null and type is not '' areswang 2008-01-16
select * from table where isnull(type,'')<>""