The information in this article applies to:
SYMPTOMSIf the IN conditional expression of the WHERE clause contains more then 15 constants and is being tested against an INT NULL column, then it will return no rows even if there are qualifying rows. WORKAROUNDUse an INT NOT NULL column to do these qualifications. STATUSMicrosoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem was corrected in Service Pack 1 for SQL Server version 6.0. For more information, contact your primary support provider. MORE INFORMATIONThe following commands demonstrate the problem:
Additional query words: sql6 Windows NT
Keywords : kbprg SSrvProg SSrvTran_SQL kbbug6.00 kbfix6.00.sp1 SSrvWinNT |
Last Reviewed: December 14, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |