The information in this article applies to:
BUG #: 15817 (6.50) SYMPTOMS
If you create a view with a CASE statement, and one or more of the result
expressions is a SELECT statement, the following error may occur:
WORKAROUNDUse the CONVERT function to convert the result of the SELECT statement to the same datatype as the other result expressions. 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 is an example of a CREATE VIEW command that will cause the
error:
To resolve the error, rewrite the query as:
Keywords : kbusage SSrvErr_Log kbbug6.50 kbfix6.50.sp2 |
Last Reviewed: April 2, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |