跨表查询
SELECT FHelpCode
FROM AIS20111018130715.dbo.t_ICItemCore
利用跨表更新进行数据恢复
UPDATE AIS20111018130715.dbo.t_ICItemCore
SET AIS20111018130715.dbo.t_ICItemCore.FHelpCode = BAKTEST.dbo.t_ICItemCore.FHelpCode
FROM AIS20111018130715.dbo.t_ICItemCore,BAKTEST.dbo.t_ICItemCore
WHERE (AIS20111018130715.dbo.t_ICItemCore.FItemID = BAKTEST.dbo.t_ICItemCore.FItemID)