假设你的表中ID为主健,自增 UPDATE tbA SET F1=B.F1,F2=B.F2,F3=B.F3 FROM tbB B WHERE 0<(SELECT COUNT(*) FROM tbA C WHERE C.ID>ID) AND 0<(SELECT COUNT(*) FROM tbB D WHERE D.ID>B.ID) 没有测试,你试一下吧.还有种直观点的写法. UPDATE tbA SET F1=(SELECT TOP 1 F1 FROM tbB),F2=(SELECT TOP 1 F2 FROM tbB),F3=... WHERE ID=(SELECT MIN(ID) FROM tbA)
upddate b set f1=a.f1,f2=a.f2 from a,b where a.id=b.id
update A Set A.filed=B.filed From B Where A.Key=B.Key
update b Set b.col1=a.col1,b.col2=a.col2 From a,b Where A.id=B.id
update b Set b.col1=a.col1,b.col2=a.col2,.... From a inner join b on A.id=B.id
go
insert into b select * from a
UPDATE tbA SET F1=B.F1,F2=B.F2,F3=B.F3 FROM tbB B WHERE 0<(SELECT COUNT(*) FROM tbA C WHERE C.ID>ID) AND 0<(SELECT COUNT(*) FROM tbB D WHERE D.ID>B.ID)
没有测试,你试一下吧.还有种直观点的写法.
UPDATE tbA SET F1=(SELECT TOP 1 F1 FROM tbB),F2=(SELECT TOP 1 F2 FROM tbB),F3=... WHERE ID=(SELECT MIN(ID) FROM tbA)
upddate b set f1=a.f1,f2=a.f2 from a,b where a.id=b.id
From B
Where A.Key=B.Key
From a,b
Where A.id=B.id
From a inner join b on A.id=B.id