如何将SQL查询的输出插入临时表中？(How to insert the output of a SQL Query into a temporary table?)

 我正在使用SQL Server 2012，并且想要使用T-SQL执行以下操作： 
 
 
 
 创建一个临时表（我们称它为#temptable ）。 
 
 
 使用SELECT语句将位于现有数据库中的表的值插入到#temptable 。 
 
 
 编写一个将查询#temptable的SELECT语句。 
 
 
 我已经尝试了以下，但它似乎语法不正确，或许我试图做的是不允许的。 
 
USE MyDatabase

CREATE TABLE #temptable
GO

INSERT INTO #TempTable
SELECT  [Col A], [Col B], [Col C]

FROM MYLIST

WHERE [MONTH OF STAY] = '2018-03-01'

AND [Property] = 'ABC'

SELECT * FROM #temptable
 
 我如何向前迈进？ 

I am using SQL Server 2012 and I want to perform the following operations using T-SQL:
 
 
 
Create a temporary table (let's call it #temptable).
 
 
Insert values from tables located in an existing database into #temptable using a SELECT statement.
 
 
Write a SELECT statement that will query the #temptable.
 
 
I have tried the following but it seems the syntax is not correct or perhaps what I am trying to do is not allowed.
 
USE MyDatabase

CREATE TABLE #temptable
GO

INSERT INTO #TempTable
SELECT  [Col A], [Col B], [Col C]

FROM MYLIST

WHERE [MONTH OF STAY] = '2018-03-01'

AND [Property] = 'ABC'

SELECT * FROM #temptable
 
How do I move forward with this?

原文：https://stackoverflow.com/questions/48474513