Last post Jul 29, 2016 10:13 AM by balu.devara
Jul 28, 2016 04:52 PM|bobh0526|LINK
I have a large stored procedure (over 800 lines). When I run it, I get this error:
Conversion failed when converting the varchar value 'Insurance' to data type int.
So it looks like I have string values in an integer column. Not sure how that happened but I would like to fix it. The problem is that I have no idea which column / table has this bad data. Is there any tricks to find something like this?
Jul 28, 2016 05:26 PM|PatriceSc|LINK
Run this is SQL Server Management Studio. You should have another line telling you where the error happened and if you double click this line, SSMS should go to this line.
Jul 29, 2016 10:13 AM|balu.devara|LINK
can you check once whether that column has any alpha numeric value or any special characters or else null or white spaces.