When to Use SELECT INTO Statements

Q

When to Use SELECT INTO Statements?

✍: fyicenter.com

A

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, 4603👍, 0💬