select FBatchManager from t_ICItem--5959那个是恢复的数据库，正常的事据库是5816select a.FBatchManager,b.FBatchManagerselect FBatchManager from t_ICItemMaterialupdate a set a.FBatchManager=b.FBatchManagerfrom t_ICItemMaterial ainner join AIS20160819165959.dbo.t_ICItemMaterial b (存储批次管理的表) on a.FItemID=b.FItemID成功select FBatchManager from t_ICItemMaterial-- 查询批次从存储批次管理表update a set a.FBatchManager=b.FBatchManager from t_ICItemMaterial a inner join AIS20160220095816.dbo.t_ICItemMaterial as b on a.fitemid=b.fitemidselect a.FBatchManager,b.FBatchManager from t_ICItemMaterial ainner join AIS20160220095816.dbo.t_ICItemMaterial b on a.FItemID=b.FItemID数据库和数据库之间的内连接要用dbo架构 不写上的话会出错 或者写..如ais2016022..t_icitem