How To Create A Table From A SELECT Statement



TODO:

Have you ever wanted to create a table from the results of a SELECT statement?

 

SOLUTION:

 

select * into newtable_tmp from oldtable

 

 

NOTES:

This statement will select all columns and records from the table "oldtable", and create a new table called "newtable_tmp" that contains the results of the SELECT statement.



Pingbacks and trackbacks (1)+

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading