Microsoft KB Archive/63869

= PRB: No Error If UPDATE or DELETE Processes 0 Rows =

Article ID: 63869

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition

-



This article was previously published under Q63869



SYMPTOMS
SQL Server does not report an error when an UPDATE or DELETE statement fails to process any rows.



CAUSE
In SQL Server, an UPDATE or DELETE statement that does not process any rows because of the conditions in the WHERE clause is considered to have executed as intended. The status returned by dbsqlexec will be SUCCEED, not FAIL. DBCOUNT can be used to determine the number of rows processed by the previous statement.

Additional query words: Windows NT dblib

Keywords: kbprogramming KB63869

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.