insert into a select * from [test2].dbo.a update a set name=b.name,value=b.value from (select * from [test2].dbo.a ) as b inner join a a1 on a1.id=b.id