All geek questions in one place

Get the name of the error column "Arithmetic overflow error converting numeric data to varchar data type."

I have a stored procedure; when i execute it i get error message

Arithmetic overflow error converting numeric data to varchar data type

Is there a way to find the column that caused this problem? I have T-SQL. Checking the columns one after the other is very tiring for us, because we have many columns (legacy system).

+4
source share
1 answer

There are many options for resolving and preventing T-SQL prodedure errors, but the answer to your question is "No." MS Does Not Make Violation Information Available.

NTN, Sean

+1

Source: https://habr.com/ru/post/1690331/

More articles:


All Articles