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