I am looking for a dynamic query that will check if my data is compatible with the data type. the data type will be passed dynamically. the data type is int.
table :- TableA
What I am trying to do is I am preparing a data migration product in that I am trying to add an exception like data type mismatch. Please make sure the query you suggest is the dynamic query.
I have a mapping table for all the columns along with their respective data types.