关于链接服务器更新的问题
update a set a.jobstate=b.jobstate,a.dptid=b.dptid,a.positionid=b.positionid,a.positionname=b.positionname
from [链接服务器].test.dbo.hrgeneral a
inner join hrgeneral b on a.hrcode=b.hrcode
inner join #TabtmpE c on a.hrcode=c.hrcode
where b.hrcode =c.hrcode
