求：sql 语句 - MS-SQL Server / 基础类

数据库db1的A表，和DB2的B表，表结构相面，PRIMARY KEY 为ID，要求将A表中B表没有的数据写入到B表中。

---

SQL code:
INSERT B
select * from db1..A a
WHERE NOT EXISTS(SELECT 1 from db2..B WHERE a.ID=b.ID)

---

SQL code:
insert db2..b
select * from db1..a t
where not exists(select 1 from db2..b where id=t.id)

---

SQL code:
--同服务器
insert db2.dbo.b
select *
from db1.dbo.a t
where not exists
(select 1 from db2.dbo.b where id=t.id)

---

SQL code:
INSERT B
select a.* from db1.dbo.A a join db2.dbo.B b on a.id=b.id
WHERE b.id is null

---

谢谢各位！