FIX: No Errors When Trying to Find Null Values in NOT NULL Col

• Microsoft SQL Server version 6.0

SYMPTOMS

If you try to find null values in columns defined as NOT NULL, then according to documentation SQL Server should generate an error message. Error messages are displayed in SQL Server 4.21a but not SQL Server 6.0.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.0. For more information, contact your primary support provider.

MORE INFORMATION

The "Transact-SQL Reference" and "Books Online" mention that if you try to find null values in columns defined as NOT NULL, SQL Server generates an error message. This is a documentation error in version 6.0. The behavior was changed in 6.0 by design. The following script will illustrate the error:

create table t (x int not null)
go
insert into t values (1)
go
select * from t where x is null 

Additional query words: SQL6 docs

Keywords          : SSrvDoc_Err kbbug6.00 kbfix6.00.sp3 
Version           : 6.0
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: March 24, 1999