I have a stored procedure; when I execute it, I get an error
我有一个存储过程;当我执行它时，我收到一个错误
Arithmetic overflow error converting numeric to data type varchar
将数值转换为数据类型varchar的算术溢出错误
Is there is way to find the column that caused this issue? I have the T-SQL. Checking columns one by one is very tedious for us because we have lots of columns (legacy system).
有没有办法找到导致此问题的列？我有T-SQL。逐个检查列对我们来说非常繁琐，因为我们有很多列（遗留系统）。
1 个解决方案
#1
1
There are many options to address and prevent the error, based on the prodedure's T-SQL, but the answer to your question is "No". MS Does not make the offending column information available.
根据prodedure的T-SQL，有很多选项可以解决和防止错误，但问题的答案是“否”。 MS不会使违规列信息可用。
HTH, Sean
HTH，肖恩
#1
1
There are many options to address and prevent the error, based on the prodedure's T-SQL, but the answer to your question is "No". MS Does not make the offending column information available.
根据prodedure的T-SQL，有很多选项可以解决和防止错误，但问题的答案是“否”。 MS不会使违规列信息可用。
HTH, Sean
HTH，肖恩