It's a question without a script because my doubt is direct.
I need to update a Column whose data is X I want to convert it to Y but when I update it gives me the following error:
Error converting Varchar to real.
so this error occurs in some trigger whose variable is declared as varchar and in the table this is declared as varchar. it turns out that in my table I do not have ANY TRIGGER and I do not know where the error is coming from when updating. My question is Is there a script that helps me check where the variable declaration error is?