The information in this article applies to:
BUG #: 15877 (6.5) SYMPTOMS
A CASE expression in the WHERE clause of a SELECT statement may cause a
handled access violation (AV).
Other processes on the server are not affected. WORKAROUNDThis problem only occurs if the variable into which the parameter values are passed to the stored procedure is used in the CASE expression of the SELECT statement. Therefore, the problem can be avoided by transferring the parameter value to another variable that is defined inside the stored procedure, and then using that second variable in the CASE expression. See the MORE INFORMATION section of this article for an example. STATUSMicrosoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider. MORE INFORMATION
The following example does not cause an access violation, because the value
in "@my_flag" is passed into the "@pass" variable, which is used in the
CASE expression:
Keywords : kbusage SSrvGPF SSrvStProc kbbug6.50 kbfix6.50.sp2 |
Last Reviewed: April 3, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |