How do I select into (local) ?

[Recce]

Good day,

I would like to know if anyone can help me with a select inti query.

I am working on a Network Server and would like to write a select into query which should insert some data into a table on my local server.

I thought it would look something like this however, this does not seem to work:

select * into [local].MyDB.dbo.Myserver

Can anyone maybe suggest how I should change this in order to be able to select into my local server please from a network server.

Regards





"We know nothing but, that what we know is not the truth..." - Me

 

[dhulbert]

You seem to be missing a from clause on that piece of code.



I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[tcsbiz]

Create the table on-the-fly:

SELECT *
INTO TabelA
FROM TableB

Insert ot an existing table:

INSERT INTO TableA (Field1, Field2, Field3)
SELECT Field1, Field2, Field3
FROM TableB