CODEWITHSUNDEEP
sql-server-2008openquery
asd
asd

Reputation: 15

SQL: OPENQUERY Question

I am currently using OPENQUERY to import Data into a Database from an Oracle Linked Server.

I am currently using SELECT INTO. It works well, but I have to drop the database and recreate it everytime i need to import the data or else i get the error: Table Already exists.

Is there another way to work with OPENQUERY which will import the data without having to Drop and recreate the table that i need?

Here is what i Have:

SELECT * INTO TEMPTBL FROM OPENQUERY(LINK, 'SELECT * FROM DATALOAD')

Thanks.

Upvotes: 1

Views: 1225

Answers (1)

Andrew S
Andrew S

Reputation: 26

Why not this? INSERT INTO PERMTBL (column list) SELECT (column list) FROM OPENQUERY(LINK, 'SELECT (column list) FROM DATALOAD')

Upvotes: 1

Related Questions