Microsoft KB Archive/203787

= PRB: Error Msg 1007: The Number Is Out of Range / Err 8115: Arithmetic Overflow =

Article ID: 203787

Article Last Modified on 11/14/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q203787



SYMPTOMS
The following error occurs when inserting a positive or negative numeric (decimal) or float number with a precision (digits in the number) greater than 28 digits:

Error -Update SpcStat PutDB (4 1007)

[Microsoft][ODBC SQL Server Driver][SQL Server]The number

'-3402823466385289000000000000000000000.0000000000'

is out of range for numeric representation (max precision: 28).

NOTE: The actual value shown in the error message will be the number that is being manipulated in the statement.



CAUSE
This behavior is by design. The default processing for a user input decimal (from the parser) is now numeric, which supports a maximum precision of 28.



WORKAROUND
If you want to input data with higher precision, do either of the following:
 * Use the exponential notation (such as 10.0E-32, 10.0e-32, 10.0E32, or 10.0e32).

-or-
 * Use trace flag 107 to bypass the numeric processing that causes the error message.

Additional query words: scientific notation

Keywords: kbprb KB203787

-

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

© Microsoft Corporation. All rights reserved.