The information in this article applies to:
BUG# NT: 12769 (6.00) SYMPTOMSIf 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. STATUSMicrosoft 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:
Additional query words: SQL6 docs
Keywords : SSrvDoc_Err kbbug6.00 kbfix6.00.sp3 |
Last Reviewed: March 24, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |