|
I have table (id int, name varchar, date2 datetime)
table 2 (date2 datetime, name varchar, id int)
The column datatypes are the same, but in a different order.
Now want to use bcp to transfer data from table to table 2
How to do?
I will report an error directly,
Msg 257, Level 16, State 3, Line 1
Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query. |
|