Imagine I have 200 columns in one
INSERT statement, and I occasionally get an "Cannot convert" error for one of columns. Things is, I do not know which column causes this error.
Is there any way in T-SQL or mybatis to check WHICH column has the incorrect format? (I have just date, char, numeric). I can use
ISDATE for every column, but this is not so elegant.
I'm using mybatis in Java, so I cannot use any
PreparedStatement or so.