INTO

SELECT INTO 与 INSERT INTO SELECT

select * into #temp from table1Code language: CSS (css)

select * into #Table_2 from Table_1
select * from #Table_2 
drop table #Table_2Code language: CSS (css)

上面等于把 table1 的数据复制到临时表 #Table_2 中。

如果要复制到另外一张实体表中，可以使用 INSERT INTO ... SELECT * FROM：

insert into Table_2
select * from Table_1Code language: JavaScript (javascript)