sql server merge data

merge data in one table from another


COPY THE CODE FROM BELOW TEXT BOX

create table test_1(iid int,vname varchar(90)) create table test_2(iid int,vname varchar(90)) insert into test_1 values(1,'X') insert into test_1 values(2,'Y') insert into test_1 values(3,'Z') insert into test_2 values(1,'A') insert into test_2 values(2,'A') insert into test_2 values(9,'A') -- update existing data first update test_2 set vname = a.vname from test_1 a join test_2 b on a.iid = b.iid select * from test_2 -- insert the new data. insert into test_2 (iid,vname) select iid,vname from test_1 where iid not in ( select iid from test_2)