title: SQL Server: Query Temporary Tables in new query windows
body: <p>I create a temp table with the following scripts</p>
  <pre><code>SELECT *
  INTO #TEMP
  FROM [mySchema].[Mytable]
  </code></pre>
  <p>The temp table location is at System Databases&gt;Tempdp&gt;temporary table&gt;dbo.#Temp</p>
  <p>How can I query the temp table in SQL Server New Query Windows from SQL Server Management Studio (SSMS) (V18.9.2)</p>
  <p>Based on Zaynul Abadin Tuhin Answer: We can query the global temp table by creating ##Temp</p>
  <p>SELECT *</p>
  <p>INTO ##TEMP</p>
  <p>FROM [mySchema].[Mytable]</p>