Is it possible to change data type of column

Question

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?

Anil Jha · Answer

yes you can convert datatype of column while inserting into other database. select convert ( varchar (10) CustomerID) from tblCustomer Here in tblCustomer table data type of CustomerID is int. I am converting to varchar. So when you insert data into other database you can convert at runtime.