--- rename table EXEC sp_rename 'myTable','myTable_OLD' --- import and create table from old table select col1, col3, col2 into myTable from myTable_OLD --- drop old table drop table myTable_OLD
SELECT col1, col2 FROM table
SELECT col2, col1 FROM table
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)