sql - 将数据插入临时表(Inserting data into a temporary table)

Question

After having created a temporary table and declaring the data types like so;

(创建临时表并声明数据类型之后;)

 CREATE TABLE #TempTable(
 ID int,
 Date datetime,
 Name char(20))

How do I then insert the relevant data which is already held on a physical table within the database?

(然后，如何插入已保存在数据库中物理表上的相关数据？)

  ask by William translate from so

Answer 1

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