|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
October 6th, 2003, 01:02 PM
|
|||
|
|||
|
Arithmetic overflow error converting numeric to data type numeric
I recently upgraded SQL7 to SQL 2000. I've migrated about 50 databases and all are working well except 1. I'm getting and error "Arithmetic overflow error converting numeric to data type numeric". The code was working before I made the upgrade. Anyone have any ideas on what is going on here. Thanks in advance.
Bill
|
|
#2
November 14th, 2003, 11:13 AM
|
|||
|
|||
|
the error typically occurs when you are trying to pass a numeric value that is too large...
example, trying to pass 12345.67 into a numeric(4,2) would generate the error.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Arithmetic overflow error converting numeric to data type numeric |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
