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

Popular Posts:

Where are all .NET C...

Where are all .NET Collection classes located ? System.Collection namespace has all the collection c...

Can two catch blocks...

Can two catch blocks be executed? No, once the proper catch section is executed the control goes fin...

How can JavaScript m...

How can JavaScript make a Web site easier to use? That is, are there certain JavaScript techniques t...

How To Change the Pa...

How To Change the Password of Another User Account? - MySQL FAQs - Managing User Accounts and Access...

what is a service co...

what is a service contract, operation contract and Data Contract? - part 1 In the below sample we ha...