When to Use SELECT INTO Statements

When to Use SELECT INTO Statements?

✍: fyicenter.com

The SELECT INTO Statement is most often used to create backup copies of tables or for archiving records.

SELECT column_name(s) INTO newtable [IN externaldatabase]
   FROM source
SELECT column_name(s) INTO newtable [IN externaldatabase]
   FROM source WHERE column_name operator value

2007-04-15, 5192👍, 0💬

Popular Posts:

Which JavaScript fil...

Which JavaScript file is referenced for validating the validators at the client side ? WebUIValidati...

How can you avoid de...

.NET INTERVIEW QUESTIONS - How can you avoid deadlock in threading? A good and careful planning can ...

How To Create an Add...

How To Create an Add-to-Google-Reader Button on Your Website? - RSS FAQs - Adding Your Feeds to RSS ...

urlencode() and urld...

What are urlencode() and urldecode() functions in PHP? string urlencode(str) - Returns the URL encod...

States of a Thread...

What are the high-level thread states? The high-level thread states are ready, running, waiting, and...