| title |
Arithmetic Errors | Microsoft Docs |
| ms.custom |
|
| ms.date |
01/19/2017 |
| ms.prod |
sql |
| ms.prod_service |
connectivity |
| ms.reviewer |
|
| ms.technology |
connectivity |
| ms.topic |
conceptual |
| helpviewer_keywords |
arithmetic errors [ODBC] |
desktop database drivers [ODBC], arithmetic errors |
|
| ms.assetid |
1c47bfac-7455-4487-b673-6b47d2a2d756 |
| author |
MightyPen |
| ms.author |
genemi |
The ODBC driver evaluates the WHERE clause in a SELECT statement as it fetches each row. If a row contains a value that causes an arithmetic error, such as divide-by-zero or numeric overflow, the driver returns all rows, but returns errors for columns with arithmetic errors. When inserting or updating, however, the ODBC driver stops inserting or updating data when the first arithmetic error is encountered.