【TRSWCM】批量更新WCMID表数据

最新推荐文章于 2021-08-09 15:13:51 发布

午夜芭蕾

最新推荐文章于 2021-08-09 15:13:51 发布

阅读量238

点赞数

分类专栏： TRSWCM

本文链接：https://blog.csdn.net/weixin_44265105/article/details/119346199

版权

这是一个SQL脚本示例，用于在数据库迁移后批量更新TRSWCM.wcmid表中的nextid字段。脚本针对多个表进行更新，包括WCMADDRESS、WCMADDRGROUP、WCMAPPENDIX等，通过查询每个表的最大ID并加1来设置nextid值。

摘要由CSDN通过智能技术生成

--批量更新WCMID表数据，数据库迁移数据之后使用。

update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMADDRESS.ADDRID),1) from TRSWCM.WCMADDRESS)+1 where TRSWCM.wcmid.tablename='WCMADDRESS';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMADDRGROUP.GROUPID),1) from TRSWCM.WCMADDRGROUP)+1 where TRSWCM.wcmid.tablename='WCMADDRGROUP';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMAPPENDIX.APPENDIXID),1) from TRSWCM.WCMAPPENDIX)+1 where TRSWCM.wcmid.tablename='WCMAPPENDIX';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMBOOKMARK.MARKID),1) from TRSWCM.WCMBOOKMARK)+1 where TRSWCM.wcmid.tablename='WCMBOOKMARK';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMBULLETIN.BULLETINID),1) from TRSWCM.WCMBULLETIN)+1 where TRSWCM.wcmid.tablename='WCMBULLETIN';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMCHANNEL.CHANNELID),1) from TRSWCM.WCMCHANNEL)+1 where TRSWCM.wcmid.tablename='WCMCHANNEL';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMCHANNELSYN.CHANNELSYNID),1) from TRSWCM.WCMCHANNELSYN)+1 where TRSWCM.wcmid.tablename='WCMCHANNELSYN';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMCHNLDOC.RECID),1) from TRSWCM.WCMCHNLDOC)+1 where TRSWCM.wcmid.tablename='WCMCHNLDOC';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMCONDITIONBEAN.CONDITIONBEANID),1) from TRSWCM.WCMCONDITIONBEAN)+1 where TRSWCM.wcmid.tablename='WCMCONDITIONBEAN';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMCONFIG.CONFIGID),1) from TRSWCM.WCMCONFIG)+1 where TRSWCM.wcmid.tablename='WCMCONFIG';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMCONTACT.CONTACTID),1) from TRSWCM.WCMCONTACT)+1 where TRSWCM.wcmid.tablename='WCMCONTACT';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMCONTENTEXTFIELD.CONTENTEXTFIELDID),1) from TRSWCM.WCMCONTENTEXTFIELD)+1 where TRSWCM.wcmid.tablename='WCMCONTENTEXTFIELD';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMCONTENTLINK.CONTENTLINKID),1) from TRSWCM.WCMCONTENTLINK)+1 where TRSWCM.wcmid.tablename='WCMCONTENTLINK';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMDOCBAK.DOCBAKID),1) from TRSWCM.WCMDOCBAK)+1 where TRSWCM.wcmid.tablename='WCMDOCBAK';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMDOCKIND.DOCKINDID),1) from TRSWCM.WCMDOCKIND)+1 where TRSWCM.wcmid.tablename='WCMDOCKIND';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMDOCREPLY.DOCREPLYID),1) from TRSWCM.WCMDOCREPLY)+1 where TRSWCM.wcmid.tablename='WCMDOCREPLY';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMDOCSYN.DOCSYNID),1) from TRSWCM.WCMDOCSYN)+1 where TRSWCM.wcmid.tablename='WCMDOCSYN';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMDOCUMENT.DOCID),1) from TRSWCM.WCMDOCUMENT)+1 where TRSWCM.wcmid.tablename='WCMDOCUMENT';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMEVENT.EVENTID),1) from TRSWCM.WCMEVENT)+1 where TRSWCM.wcmid.tablename='WCMEVENT';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMEVENTTYPE.EVENTTYPEID),1) from TRSWCM.WCMEVENTTYPE)+1 where TRSWCM.wcmid.tablename='WCMEVENTTYPE';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMEXPIRATION.EXPID),1) from TRSWCM.WCMEXPIRATION)+1 where TRSWCM.wcmid.tablename='WCMEXPIRATION';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMEXTFIELD.EXTFIELDID),1) from TRSWCM.WCMEXTFIELD)+1 where TRSWCM.wcmid.tablename='WCMEXTFIELD';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMFILETYPE.FILETYPEID),1) from TRSWCM.WCMFILETYPE)+1 where TRSWCM.wcmid.tablename='WCMFILETYPE';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMFLOW.FLOWID),1) from TRSWCM.WCMFLOW)+1 where TRSWCM.wcmid.tablename='WCMFLOW';
update TRSWCM.wcmid set TRSWCM.wcmid.nextid=(select isnull(max(TRSWCM.WCMFLOWACTION.ACTIONID),1) from TRSWCM.WCMFLOWACTION)+1 where TRSWCM.wcmid.tablename='WCMFLOWACTION';
update TRSWCM.wcmid set TRSWCM