Posted By

username on 10/19/10


Tagged


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

Tyster


SQL stores result in Temp table


 / Published in: SQL
 

  1. SELECT camping_rec.user,
  2. "CS123" camp, -- comment
  3. " " v15
  4. FROM camping_rec
  5. WHERE camp = 'ACE' -- comment
  6. INTO temp b_0 WITH no log;
  7.  
  8. ...
  9. SELECT * FROM b_0;
  10.  
  11. ...
  12. DROP TABLE b_0;

Report this snippet  

You need to login to post a comment.