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

Popular Posts:

Well-Written Object ...

What does a well-written Object Oriented program look like? A well-written object oriented program e...

How did you implemen...

How did you implement UML in your project ? PART II Implementation phase / Coding phase (Class diagr...

What is a XML parser...

What are the standard ways of parsing XML document? XML parser sits in between the XML document and ...

How do you hide Publ...

Managed Code and Unmanaged Code related ASP.NET - How do you hide Public .NET Classes and other publ...

Can you explain diff...

What are different properties provided by Objectoriented systems ? Following are characteristic’s of...