title: using SELECT INTO with multiple rows
body: <p>This is re 
  I want to create a table using the results of a query by utilizing SELECT INTO.
  The syntax</p>
  
  <pre><code>SELECT *
  INTO Persons_Backup
  FROM Persons
  </code></pre>
  
  <p>is very close to what I want to achieve, with the difference being that I want the FROM to use a query as source.</p>
  
  <p>My situation is a bit more complicated than these simple examples.</p>
  
  <p>I need to create a table and insert multiple rows at the same time. If I could (I can't) use a previously created table the statement would look like this:</p>
  
  <pre><code>INSERT INTO Person_Backup12 (Col1, Col2, Col3)
  Select 1, 'a','2001-01-01 12:00'
  UNION ALL
  Select 83, 'z','2011-09-30 13:27'
  UNION ALL
  Select 777, 'k','1997-04-25 09:27'
  </code></pre>
  
  <p>Can I do that while creating a table at the same time?</p>