I will change the code like what you had said but when it was having issues with the Test_Code Column in the Table_Test1 . It should throw an error message like it cannot convert 1000 to 1001 but why was it throwing an error message like the one mentioned below.

Conversion failed when converting the varchar value '2314K' to data type int. [SQLSTATE 22018] (Error 245).