NC57银行档案和客商银行账号为建行04 UPDATE

时间：2024-04-29 13:46:19

第二步

银行档案

update bd_bankdoc set bankdoccode='04N'|| bankdoccode , pk_banktype='0001ZZ1000000001OCUD' where

pk_banktype<>'0001ZZ1000000001OCUD'

   and bankdocname like '%建%'

   and   bankdocname not like '工%'

   and   bankdocname not like '%工商%'

     and bankdocname not like '%农%'

   and bankdocname not like '中行%'

   and bankdocname not like '中国银行%'

     and bankdocname not like '%民生银行%'

      and bankdocname not like '%招商%'

        and bankdocname not like '%南昌银行%'

         and bankdocname not like '交%'

          and bankdocname not like '保定银行%'

          and bankdocname not like '%建工%'

          and bankdocname not like '%邮政%'

第一步

客商银行账户

提醒：如果上面是第一步导致上面的更新完，下面查不到东西

update bd_bankaccbas

 set pk_bankdoc='0001ZZ1000000001OCUD'  where pk_bankdoc in(

select pk_bankdoc from bd_bankdoc

   where pk_banktype<>'0001ZZ1000000001OCUD'

   and bankdocname like '%建%'

   and   bankdocname not like '工%'

   and   bankdocname not like '%工商%'

     and bankdocname not like '%农%'

   and bankdocname not like '中行%'

   and bankdocname not like '中国银行%'

     and bankdocname not like '%民生银行%'

      and bankdocname not like '%招商%'

        and bankdocname not like '%南昌银行%'

         and bankdocname not like '交%'

          and bankdocname not like '保定银行%'

          and bankdocname not like '%建工%'

          and bankdocname not like '%邮政%' )

不敢更新，貌似有问题，更新之后开户以后空了