SQL Server 2008 copy table with changing physical sequence of fields

Question

The task is to copy

table1 ( A,C,B )

to

table2 ( A,B,C ) 

Tables effectively identical, the same fields/constraints just physical sequence of fields is different. Can I do it with standard tools and minimal coding. For bulk copy in this case mapping for each field pair seems to be required.

Answer 1

If I've understood your question correctly, you can just copy the table without changes and then change the ordering afterwards. Change the field order by dragging the column in Design mode in SQL Enterprise Manager.

Answer 2

This seems to be a simple

insert into table2(A,B,C)
select A,B,C from table1