34,593
社区成员
发帖
与我相关
我的任务
分享
update A set zt=8 where ysdbh in(select ysdbh from B with(nolock))
update A
set zt = 8
from b
where ysdzt COLLATE Chinese_PRC_CI_AS= B.ysdzt COLLATE Chinese_PRC_CI_AS
update A
set zt = 8
from A,B
where A.ysdzt = B.ysdzt
update A
set zt = 8
from b
where ysdzt = B.ysdzt
-->try
update A set zt=8 where ysdbh COLLATE Chinese_PRC_CI_AS in(select ysdbh from B with(nolock))
--or
update A set zt=8 where ysdbh COLLATE Chinese_PRC_CI_AI in(select ysdbh from B with(nolock))
update A set zt=8 where ysdbh in(select ysdbh from B with(nolock) COLLATE Chinese_PRC_CI_AS)