Loading

Is it possible to change data type of column

Nepethya Rana

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?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Anil Jha9y ago
Accepted 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.