Error: Arithmetic overflow error converting numeric to data type numeric

Z

Zeng

Hello,

I'm using adonet to update the database hundreds of fields all at once and
got this exception/error:
"Arithmetic overflow error converting numeric to data type numeric", but it
doesn't tell me which specific column got overflown. Is there a way to find
out ? I have access to both the update code and the sql server.

Thank you very much in advance...
 
W

Wayne Snyder

Although I am not much of an ADO.Net person, I think that you get an errors
collection.... SQL does return more info... Either it is in one of the other
messages or the one you are seeing is truncated... I did an arithmetic
overflow and got the following message..

Server: Msg 220, Level 16, State 2, Line 2
Arithmetic overflow error for data type tinyint, value = 3500.

--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
 
R

Ramesh

hii
change the size of all your numeric fields in th data base to 38 and
precison to 0 and see..
ramesh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Arithmetic overflow error converting numeric to data type numeric. 4
Numeric Field Overflow Error 5
Linking table gets numeric field overflow 2
Error converting data type numeric to decimal? 1
Access Overflow error 3
Error converting numeric to decimal? 9
Numeric Field Overflow when appending date - how to convert it to text 1
"Arithmetic overflow error converting expression to data type datetime" error 4

Top