The information in this article applies to:
BUG #: 17132 SYMPTOMS
If you perform an UPDATE of a cursor that contains a WHERE clause and if
the underlying table does not have a primary key, the UPDATE may fail to
continue because the cursor breaks out after the first fetch. The following
scripts demonstrate this problem:
WORKAROUND
You can avoid this problem by creating the table with a primary key. The
following scripts demonstrate the workaround for this problem:
STATUSMicrosoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. Additional query words: t-sql tran-sql tsql transql
Keywords : kbusage SSrvTran_SQL kbbug6.50 |
Last Reviewed: April 21, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |