Skip to content

Latest commit

 

History

History
15 lines (15 loc) · 738 Bytes

File metadata and controls

15 lines (15 loc) · 738 Bytes
title Arithmetic Errors
description Arithmetic Errors
author David-Engel
ms.author v-davidengel
ms.date 01/19/2017
ms.service sql
ms.subservice connectivity
ms.topic conceptual
helpviewer_keywords
arithmetic errors [ODBC]
desktop database drivers [ODBC], arithmetic errors

Arithmetic Errors

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.