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
