title: How to SELECT * INTO [tmp table] without declare table?
body: <p>i want use select statement on the a table and inserting result into a temp table variable, but i don't declare temp table with columns and i want use like this:</p>
  
  <pre><code>Declare #tmp table;
  
  SELECT * INTO #tmp FROM myTable
  </code></pre>
  
  <p>this want declare columns and data types for #tmp</p>
  
  <p>please help me</p>