remote: a table from linked server, such as remotelink.testdb.dbo.test
local: a local table
I need to insert the data which sit on local but doesn't sit on remove, the sql is like the following, is it a distribute transaction?
select period_key,value,id from local where id not in (select id from remote)
select period_key,value,id from
(select *, rownum_over (partition_by period_key order by value) rownum from missing_in_remote where rownum=1
insert into remote select * from missing_in_remote
View Complete Post