*****一個資料表拆成兩個***** 如果是已經有序號的~~ 例如：SELECT 序號,欄位1,欄位2,欄位3,欄位4,欄位5 FROM Sales→要拆成兩個 SELECT 序號,欄位1,欄位2,欄位3 FROM Sales SELECT 序號,欄位4,欄位5 INTO new_table FROM Sales 如果是自己給的ROWNUMBER序號~~ 例如：SELECT ROW_NUMBER() OVER(ORDER BY SalesTD..