备份字段（CATALOGUE_CODE）

update am_e4_entry set CATALOGUE_CODE_back=CATALOGUE_CODE;

还原字段

update am_e4_entry a set CATALOGUE_CODE=Get_StrArrayStrOfIndex(a.ARCHIVAL_CODE,‘-‘,1) where a.CATALOGUE_CODE is not null and a.ARCHIVAL_CODE is not null;

截取对比

select Get_StrArrayStrOfIndex(a.ARCHIVAL_CODE,‘-‘,1),a.ARCHIVAL_CODE,a.CATALOGUE_CODE from am_e4_entry a where Get_StrArrayStrOfIndex(a.ARCHIVAL_CODE,‘-‘,1)<>a.CATALOGUE_CODE
and a.CATALOGUE_CODE is not null and a.ARCHIVAL_CODE is not null;

备份字段（CATALOGUE_CODE）

原文：http://www.cnblogs.com/ylldbk/p/5524149.html