is null and is not null?

2007-04-19 11:16 +0800

在SQL Server 2000中遇到一个怪问题。执行下面语句，居然返回大量结果：

select * from info where uid is null and uid is not null

研究返回的字段值，没有发现有什么异常。重建索引也没解决问题。

最后，把整个表导出成文本文件，返回再导入。问题解决！

本文来自http://jijian91.com  原文http://jijian91.com/blog20070419/sqlserver-is-null-and-is-not-null.html

Google
归类于： SQL Server — jijian91  
添加到网络书签：                                                                

评论

Good.Be the first to comment on this entry.

Post comment

comment has COPYRIGHT too！

Fields in bold are required. Email addresses are never published or distributed.

Some HTML code is allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>
URIs must be fully qualified (eg: http://www.domainname.com) and all tags must be properly closed.

Line breaks and paragraphs are automatically converted.

Please keep comments relevant. Off-topic, offensive or inappropriate comments may be edited or removed.