T-SQL Arithmetic overflow: which column?

Question

In MS SQL Server 2005, when encountering an "Arithmetic overflow error converting numeric to data type numeric" during an INSERT, is it possible to discover which column's input value caused the error?

There seems to be a number of similar conversion errors that don't report which column provoked the trouble. This makes fixing mistakes rather difficult in huge queries. Is there some other way to deal with this?

it use to happen to me also, but with binary or string data truncated — Jhonny D. Cano -Leftware-
– Jhonny D. Cano -Leftware-, Commented Apr 13, 2009 at 15:15

user16316 · Accepted Answer · 2009-04-13 15:21:29Z

2

As far as i know, No, you can't get the error message to show you in which column is failing. But, if you know what you are inserting you should be able to find where the error is. Why don't you put the table structure and the insert query.

answered Apr 13, 2009 at 15:21

user16316

Sign up to request clarification or add additional context in comments.

1 Comment

Mentat Over a year ago

Thanks, I can indeed find the find the problem field manually (though this is in the context of a web app, which makes it more tedious); it just seems ridiculous that I should have to bother.

Collectives™ on Stack Overflow

T-SQL Arithmetic overflow: which column?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related