.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

When to Use SELECT INTO Statements

Q

When to Use SELECT INTO Statements?

✍: fyicenter.com

A

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

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML