bcp transfer data, different table order

70859800

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.

prajna

Output in queryout

prajna

Specify field order

70859800

Because there are many tables to bcp, such as specifying the order of the fields is definitely not flexible

70859800

Output in queryout mode, very strong Ah! Can it support input parameters? variable?