INSERT INTO #TempTable(ID, Date, Name)
SELECT OtherID, OtherDate, OtherName FROM PhysicalTable

正确的查询:

drop table #tmp_table

select new_acc_no, count(new_acc_no) as count1
into #tmp_table
from table
where unit_id = '0007' 
group by unit_id, new_acc_no
having count(new_acc_no) > 1

INSERT INTO #TempTable (ID, Date, Name) 
SELECT id, date, name 
FROM physical_table

insert into #temptable (col1, col2, col3)
select col1, col2, col3 from othertable

注意，这被认为是糟糕的做法:

insert into #temptable 
select col1, col2, col3 from othertable

如果临时表的定义要更改，则代码可能在运行时失败。

SELECT  ID , Date , Name into #temp from [TableName]

insert #temptable
select idfield, datefield, namefield from yourrealtable