Select Into Query Help

[gunapriyan]

Dear Friends,

Good Morning.

Once again i am coming with a new request.......

I want to insert the local db tables values into my hosters Database.

And i want to insert the 8 table values into remote 8 tables in a single shot with a where clause.

In this manner, i am going to use the following code.....If its wrong, please correct it..


Select * into servername.database.dbo.table1 from tabel1 where id='TG123'

Select * into servername.database.dbo.table2 from tabel2 where id='TG123'

Select * into servername.database.dbo.table3 from tabel3 where id='TG123'

Select * into servername.database.dbo.table4 from tabel4 where id='TG123'

Select * into servername.database.dbo.table5 from tabel5 where id='TG123'

Select * into servername.database.dbo.table6 from tabel6 where id='TG123'

Select * into servername.database.dbo.table7 from tabel7 where id='TG123'

Select * into servername.database.dbo.table8 from tabel8 where id='TG123'


Thanks in advance.

Yours
GUNA

[leinad31]

Check syntax of INSERT INTO...SELECT... statement

[gunapriyan]

My Friend,

Can you help in syntax for my goal?

Thanks in advance.

- Guna

[abhijit]

The syntax to insert into a table usually starts with
INSERT INTO <tablename> <fields> SELECT <fields> from <tablename>