问题现象:如何用语句快速删除用友U8ERP软件中的帐套 ?因升级帐套太多,手工删除太慢
解决方案: 提供语句解决:
DECLARE @AccID char(3)
SET @AccId = '112'--在此修改账套号
USE UFSYSTEM
DELETE FROM UA_BackupLog WHERE cAcc_Id=@AccId
DELETE FROM UA_BackupPlans WHERE cAcc_Id=@AccId
DELETE FROM UA_BackupPlan WHERE cPlan_Id not in (select cPlan_Id FROM UA_BackupPlans)
DELETE FROM UA_HoldAuth WHERE cAcc_Id=@AccId
DELETE FROM UA_Auth WHERE cAcc_Id=@AccId
DELETE FROM UA_FlowItems WHERE cAccId=@AccId
DELETE FROM UA_FlowLines WHERE cAccId=@AccId
DELETE FROM UA_Identity WHERE cAcc_Id=@AccId
DELETE FROM UA_Account_sub WHERE cAcc_Id=@AccId
DELETE FROM UA_Log WHERE cAcc_Id=@AccId
DELETE FROM UA_Period WHERE cAcc_Id=@AccId
DELETE FROM UA_Account WHERE cAcc_Id=@AccId
DELETE FROM UA_Message WHERE Account=@AccId
DELETE GDP_JccpConfigure WHERE UF_DB_NAME=@AccId
USE master
DECLARE AccCur CURSOR
FOR SELECT NAME FROM sysdatabases
DECLARE @AccName varchar(40)
OPEN AccCur
FETCH NEXT FROM AccCur INTO @AccName
WHILE (@@fetch_status <>; -1)
BEGIN
IF (@@fetch_status <>; -2)
BEGIN
IF (left(@AccName,10)='UFDATA_' + @AccId) and len(@AccName)=15
BEGIN
EXECUTE sp_detach_db @AccName
--PRINT '账套库'+@AccName + '已分离!'
END
END
FETCH NEXT FROM AccCur INTO @AccName
END
CLOSE AccCur
DEALLOCATE AccCur
SELECT '账套'+@AccId+'删除完成!'
温馨提示:近期载地址失效频繁,如链接失效请点击此处查阅详情!
问题现象:用友client.dll出错的解决办法?很多用户碰到这样的情况:打开企业门户后提示“登陆失败”或“连接不到服务器”,打开系统管理提示“运行时错误:53(48).文件未找到:client.dl...
问题现象:出纳模块制单提示:在外部凭证表中没有当前操作员传送的记录 ? 出纳管理,在日记账制单时提示: ---------------------------凭证-----------------...
问题现象:用友U8 应收管理中做付款单,表体项目中对方科目显示不出来。? 用友U8 应收管理中做付款单,表体项目中对方科目显示不出来,用户称原来是好的 问题原因:操作问题,用户在选项中改过了设置,原...
问题现象:用友U852ERP软件工资结转失败?问题现象:win2kSvr+u851+工资管理工资结转年度数据提示: INSERT INTO WA_GZData SELECT * FROM UFDATA...
问题现象:用友U8数据库日志清理方法?日志清理方法:如果日志很大,会造成软件自动备份失败,所以需要定期清理数据库日志。 打开SQL查询分析器 use ufsystem //打...
问题现象:用友U8软件在做报检处理保存提示“来源生产订单已经改变或删除”?问题现象:做了一张非标准生产订单,该订单是成品改制订单,订单的内容是一个成品,不需要检验,在改制过程中需要领用材料及其他子件,...