Sql-Server Select into From query

Question

你好，我正面临着以下挑战:

我正在使用SQL SERVER，我想做以下操作:

SELECT * INTO existingTable
FROM (SELECT * FROM tbl);

我想知道如何获得查询结果到一个表与SQL语句

Answer 1

删除from和(括号)

insert into existingTable 
select * from tbl

将列显式命名为

将是良好的实践

insert into existingTable (colA, colB, ... )
select col1, col2, ... from tbl

Answer 2

如果表之间的字段不相同，则必须将它们键入:

Insert Into existingTable (field1, field2, field3, ...)
SELECT field1, field2, field3, ... from tbl