假设你的表中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)