The information in this article applies to:
BUG #: 18841 (SQLBUG_65) BUG #: 56518 (SQLBUG_70) SYMPTOMSWhen you execute either of the following two statements, against the PUBS database, they may generate an Access Violation:
-or-
CAUSEThe problem is caused by the multiple expressions returned by the innermost SELECT statement causing either the COALESCE or NULLIF functions to fail. In fact, when executed on SQL Server 7.0, an error message similar to the following may occur:
WORKAROUNDAvoid using the COALESCE and NULLIF functions with multiple expressions as parameters. STATUSMicrosoft has confirmed this to be a problem in SQL Server version 6.5 and 7.0. Additional query words: nullif coalesce T-SQL
Keywords : SSrvErr_Log SSrvISQL SSrvTran_SQL kbbug6.50 kbbug7.00 kbSQLServ650bug kbSQLServ700bug |
Last Reviewed: October 14, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |