sql：
-- 临时表 select * into #sysorgtemp from SysOrg(nolock); select * into #producttemp from ( select ProductId,BdId,p.OrgId productOrgId,u.OrgId userOrgId from Product(nolock) p left join SysUser u on p.BdId = u.LoginId where p.OrgId is null and p.BdId is not null ) temp where temp.userOrgId is not NULL; -- 这里，可以加sql把要更新的数据，备份到一张备份表