34,590
社区成员
发帖
与我相关
我的任务
分享
update B set L = d.E from B c join (select a.c,a.d,a.l,a.m,a,n,b.E from B a join A b on a.C=b.C AND a.D=b.D AND b.F<a.M AND b.G>a.N )) d on c.d=d.d and c.c=d.c and c.l=d.l and c.n=d.n and c.m=d.m
update B
set L = A.E
from A,b
where A.C=B.C
AND A.D=B.D
AND A.F<B.M
AND A.G>B.N
update B
set L = d.E
from B c join (select a.c,a.d,a.l,a.m,a,n,b.E from B a join A b on a.C=b.C
AND a.D=b.D
AND b.F<a.M
AND b.G>a.N
)) d on c.d=d.d and c.c=d.c and c.l=d.l and c.n=d.n and c.m=d.m
update B
set L = d.E
from B c join (select a.c,a.d,a.l,a.m,a,n,b.E from B a join A b on a.C=b.C
AND a.D=b.D
AND a.F<b.M
AND a.G>b.N
)) d on c.d=d.d and c.c=d.c and c.l=d.l and c.n=d.n and c.m=d.m
update B
set L = b.E
from B c join (select a.c,a.d,a.l,a.m,a,n from B a where exeists(select 1 from A where A.C=b.C
AND A.D=b.D
AND A.F<b.M
AND A.G>b.N
)) d on c.d=d.d and c.c=d.c and c.l=d.l and c.n=d.n and c.m=d.m
--避免其他业务影响 增加HOLDLOCK 但其他访问会被阻塞
--将A B 表中的 C D字段作为索引 会加快update定位速度 节省一点时间
update B set B.L = A.E from A with(HOLDLOCK) ,B with(HOLDLOCK) where A.C=B.C AND A.D = B.D AND A.F < B.M AND A.G > B.N
update b set l=a.e
from a,b where a.c=b.c and a.d=b.d and a.f<b.m and a.g>b.n