Seeking: Insert a table data into an existing table

ykkevin

correct:
Rename table B after rebuilding the index on table C

wgfxman

Link server+

INSET into B
SELECT * FROM LinkServer.dbo.A where NOT EXISTS (SELECT 1 FROM B WHERE primary key=A. primary key)