用友u8修改启用日期

begin tran aa

update UFDATA_999_2003..Accinformation set cvalue='' where cname='dqMPeriodDate' and cSysID='qM'

go

update UFDATA_999_2003..Accinformation set cvalue='' where cname='dqMNatureDate' and cSysID='qM'

go

update UFDATA_999_2003..Accinformation set cvalue='' where cname='dpPeriodDate' and cSysID='pp'

go

update UFDATA_999_2003..Accinformation set cvalue='' where cname='dppNatureDate' and cSysID='pp'

delete from ufsystem..ua_account_sub where cAcc_Id='999' and iYear='2003' and cSub_Id='pp'

delete from ufsystem..ua_account_sub where cAcc_Id='999' and iYear='2003' and cSub_Id='qm'

go

if @@error >1

begin

rollback tran aa

end

else

begin

commit tran aa

end