Hi, I would like to know how to modify the following selects
so that - assuming that NewTable already exists - the result of the
SELECT is appended to the existing table.

If possible I need the appropriate changes for both the 2 syntax
below.

-1-
SELECT * INTO NewTable FROM (
SELECT
S.OrderID AS "OrderID",
S.CustomerID AS "CustomerID"
FROM
Source1 S
) tmp

-2-
CREATE TABLE NewTable
SELECT
S.OrderID AS "OrderID",
S.CustomerID AS "CustomerID"
FROM
Source1 S


Thank you very much for any help,

Pam

To insert into a table that already exists you use INSERT INTO. In your case
it will be something like this:

INSERT INTO NewTable (OrderID, CustomerID)
SELECT OrderID, CustomerID
FROM Source1

This assumes table NewTable already exists. If the table does not exist you
can create it with SELECT INTO like this:

SELECT OrderID, CustomerID
INTO NewTable
FROM Source1

HTH,

Plamen Ratchev
http://www.SQLStudio.com

You can also create a table using SELECT INTO
without putting anything in it ---

SELECT OrderID, CustomerID
INTO NewTable
FROM SourceTable
WHERE 1=2

Thank you all. Very helpful.

the CREATE TABLE syntax is more an Oracle thing. Right?

I was wondering if the
SELECT INTO
INSERT INTO
syntax is also accepted by Oracle or it needs adjustments ?

-Pam

"pamela fluente" <pamelafluente (AT) libero (DOT) it> wrote

Yes, using CREATE TABLE to create a table from another table works in Oracle
but not in SQL Server. In Oracle you can write:

CREATE TABLE NewTable AS
SELECT OrderID, CustomerID
FROM Source1

The equivalent in SQL Server is:

SELECT OrderID, CustomerID
INTO NewTable
FROM Source1

There is SELECT INTO in Oracle but has different meaning. The INTO clause is
used to direct the result of the SELECT to a variable list or a record.

INSERT INTO in its basic form works the same way in Oracle and SQL Server.
Oracle has more variations of the syntax.


HTH,

Plamen Ratchev
http://www.SQLStudio.com

On 22 Feb, 21:02, "Plamen Ratchev" <Pla... (AT) SQLStudio (DOT) com> wrote:
Thank you. Very useful.

-Pam