未规范化的表--(DTS)-->TEMPTAB
INSERT INTO 客户表 SELECT COL1,COL2,COL3... FROM TEMPTAB
INSERT INTO 订单表 SELECT COL2,COL3,COL4... FROM TEMPTAB
.......
INSERT INTO 客户表 SELECT COL1,COL2,COL3... FROM TEMPTAB
INSERT INTO 订单表 SELECT COL2,COL3,COL4... FROM TEMPTAB
.......
select identity(int,1000,1) as itemno,col1 as khname,col2 as tel
into 客户表 from oldtable