数据库恢复我学到了

update Jxc_Spxx a set Spmc =
  (select
     Spmc
   from
     Jxc_Spxx_Bak b
   where a.Spbm = b.Spbm);

从备份表中恢复数据