--先把b中有a的id的紀錄刪除,再把a整體到進去 delete dbB.dbo.b where exists(select 1 from dbA.dbo.a where id=dbB.dbo.b.id)insert into dbB.dbo.b select * from dbA.dbo.a--或者 update dbB.dbo.b set XX=XX where exists(select 1 from dbA.dbo.a where id=dbB.dbo.b.id)insert into dbB.dbo.b select * from dbA.dbo.a where not exists(select 1 from dbB.dbo.b where id=dbA.dbo.a.id)
谢谢挤挤乳沟~~update dbB.dbo.b set XX=XX where exists(select 1 from dbA.dbo.a where id=dbB.dbo.b.id) 这里的set XX=XX,如有100个字段还要手工一个个写吗,我想覆盖表b中所有对应的纪录,应该如何写?
delete dbB.dbo.b where exists(select 1 from dbA.dbo.a where id=dbB.dbo.b.id)insert into dbB.dbo.b select * from dbA.dbo.a--或者
update dbB.dbo.b
set XX=XX
where exists(select 1 from dbA.dbo.a where id=dbB.dbo.b.id)insert into dbB.dbo.b
select * from dbA.dbo.a where not exists(select 1 from dbB.dbo.b where id=dbA.dbo.a.id)
set XX=XX
where exists(select 1 from dbA.dbo.a where id=dbB.dbo.b.id) 这里的set XX=XX,如有100个字段还要手工一个个写吗,我想覆盖表b中所有对应的纪录,应该如何写?