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

Popular Posts:

Can two catch blocks...

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

Are risk constant th...

Are risk constant through out the project ? * Never say that risk is high through out the project. R...

Can you prevent a cl...

Can you prevent a class from overriding ? If you define a class as “Sealed” in C# and “NotInheritab...

How To Control Verti...

How To Control Vertical Alignment? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells By d...

How to create arrays...

How to create arrays in JavaScript? We can declare an array like this var scripts = new Array(); We ...