Is it possible to change data type of column

Jul 5 2017 1:30 AM

Is it possible to change data type of column retrieved from one table which is in varchar to an integer while inserting to another table.

My situation is I retrieved records from a database table and store in a dataset.

From this dataset i need to insert this records to another database.

So while i do insert operation, can i cange the datatype so that it could match the data type define in my second table?

Answers (1)