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

Popular Posts:

What is Native Image...

What is Native Image Generator (Ngen.exe)? The Native Image Generator utility (Ngen.exe) allows you ...

Shift Operators...

What will be printed as the result of the operation below: main() { int x=5; printf("%d,%d,%d\n",x,x. ..

What is Shell script...

What is Shell scripting A shell script is a script written for the shell, or command line interprete...

How do I install JUn...

How do I install JUnit? First I will download the lastest version of JUnit. Then I will extract all ...

. How can a servlet ...

. How can a servlet refresh automatically if some new data has entered the database? You can use a c...