Evo ti opsti primeri, pa ti vidi sta mozes da iskoristis:
Primer br. 1 - Bezuslovni insert
Code:
INSERT INTO Baza1.dbo.Tabela SELECT * FROM Baza2.dbo.Tabela
Primer br. 2 - Insert samo nepostojecih slogova (uslov je ID)
Code:
INSERT INTO Baza1.dbo.Tabela SELECT * FROM Baza2.dbo.Tabela WHERE Baza2.dbo.Tabela.ID NOT IN (SELECT ID FROM Baza1.dbo.Tabela)