Thursday, August 02, 2007

Useful SQLs

1. select * into Customer_tmp from Customer [any where conditions if needed]
Select entries from Customer table and create a new table Customer_tmp with the same structure of Customer and Insert them into the new table.
Useful to copy a table to a tmpTable.

No comments: