title: How to insert into a temporary table?
body: <p>I'm working with Sybase Central using Adaptive Server Anywhere 9 and I want some examples of how to use tempDB.</p>
  
  <p>How can I insert some records in to a temporary table?</p>
  
  <p>I tried:</p>
  
  <pre><code>select * into TempDB.dba.#testing from testTable
  </code></pre>
  
  <p>But I got the following error:</p>
  
  <blockquote>
    <p>Syntax error near '.' on line 1</p>
  </blockquote>