I am facing the problem: Try Catch block is not work that try block failed but catch block is not excuted.
In my case, I tried to excuted the sql like below:
update [table] set [column] = abc
select 'catch error'
The [column] is numeric format, but data set to it is not valid number.
When excute this sql, the following error prompt out:
Invalid column name 'abc'.
And the catch block has not been excuted.
I want to know what happen in this case.
Moreover, I found an article talks about the similar case too:
Is there any solution so that I can catch the error without stopping the batch?
Thanks a lot.
View Complete Post