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

Popular Posts:

calloc() and malloc(...

What is the difference between "calloc(...)" and "malloc(...)"? 1. calloc(...) allocates a block of ...

What are unadjusted ...

What are unadjusted function points and how is it calculated? Unadjusted function points = ILF + EIF...

JSP Tags vs. JavaBea...

What is difference between custom JSP tags and JavaBeans? Custom JSP tag is a tag you defined. You d...

"const" and "volatil...

Can a variable be both const and volatile? Yes. The const modifier means that this code cannot chang...

Clone of Map Objects...

Jack developed a program by using a Map container to hold key/value pairs. He wanted to make a chang...