SQL SELECT INTO

Send request to get interview tips in PDF format Personal Interview - Answers to frequently asked questions Tips to earn promotions and perks You can also get your answers published How to write a good CV? How to write a good Cover Letter? Tips to become boss's favorite CareerRide is hiring

SQL SELECT INTO - Introduction and syntax 

---

<<Previous  Next>>

SQL - Dec 03, 2008 at 18:00 PM by Rajmeet Ghai

Explain the SQL SELECT INTO statement. Write SQL syntax for the SQL SELECT INTO statement along with an example.

SQL SELECT INTO: The SELECT INTO statement selects data from one table and inserts it into a different table. Used often for creating back up’s.

Syntax:
SELECT * INTO new_table_name [IN externaldatabase] FROM old_tablename

Example:
SELECT * INTO employee_Backup FROM employee

<<Previous  Next>>