How to identify the culprit in "Error converting data type varchar to numeric"?

Posted by Stan on Stack Overflow See other posts from Stack Overflow or by Stan
Published on 2010-05-24T18:58:42Z Indexed on 2010/05/24 19:01 UTC
Read the original article Hit count: 168

Filed under:

An insert statement with a large number of values returns 'Error converting data type varchar to numeric.'

How can I find which value actually triggers the error?

MS SQL Server 2008 is used.

© Stack Overflow or respective owner

Related posts about sql-server-2008