Select Into & Insert Into

Select Into & Insert Into

下列指令會先創建newTable欄位與sourceTable一致，再將sourceTable的資料全部複製到newTable, newTable事先必須不存在
--select * into newTable from sourceTable

下列指令會將sourceTale的資料全部複製到newTable, newTable事先必須存在, 兩者欄位必須相同
--Insert into newTable select * from sourceTable