--µ¥¾Ý truncate table QMSaleCkRequest truncate table QMSaleCkRequestEntry truncate table QMINQCReq truncate table QMINQCReqEntry truncate table ICQCBill truncate table QMSourceInfo truncate table PPOrder truncate table PPOrderEntry truncate table ICExpenses truncate table ICExpensesEntry truncate table ICInvBackup truncate table ICQCScheme truncate table ICQCSchemeEntry --¹Ì¶¨×ʲú truncate table T_FACard truncate table T_FACardItem truncate table T_FADevice truncate table T_FAOrgFor truncate table T_FADept truncate table T_FAExpense truncate table t_FAPurchase truncate table T_FAbalCard truncate table T_FAbalCardItem truncate table T_FAbalDevice truncate table T_FAbalOrgFor truncate table T_FAbalDept truncate table T_FAbalExpense truncate table t_FAbalPurchase truncate table t_FAVoucher truncate table t_FAClear DELETE FROM T_FAAlter DELETE FROM t_FAbalance truncate table t_RP_NewReceiveBill truncate table t_RP_Contact truncate table t_rp_ARBillOfSH truncate table t_rp_AdjustAccount truncate table t_rp_AdjustRate truncate table t_rp_AdjustRateEntry truncate table t_rp_ARBillOfSH truncate table t_RP_ARPBill truncate table t_rp_arpbillEntry truncate table t_rp_BegData truncate table t_rp_BegDataEntry truncate table t_RP_Bill truncate table t_rp_bill_discount truncate table t_RP_Bill_Endorse truncate table t_RP_Bill_Settle truncate table t_Rp_CheckDetail truncate table t_rp_CheckDetail20120517134445300 truncate table t_rp_CheckEntry truncate table t_RP_Contact truncate table t_RP_ContactBal truncate table t_rp_ContractPlanReceive truncate table t_RP_NewReceiveBill truncate table t_rp_PayApplyBill truncate table t_rp_PayApplyBillEntry truncate table t_RP_Plan_Ap truncate table t_RP_Plan_Ar truncate table t_RPContract truncate table t_rpContractEntry truncate table t_RPContractScheme truncate table t_RPVoucherAndBill truncate table t_RP_NewCheckInfo DELETE FROM t_Item_3003 DELETE FROM t_Item_3004 DELETE FROM t_Item_3005 DELETE FROM t_Item_3006 DELETE FROM t_Item_3009 truncate table ICStockBill truncate table ICPlanAdjPrice truncate table POrequest truncate table POOrder truncate table POInstock truncate table POInstock truncate table ICPurchase truncate table ICSale truncate table SEOrder truncate table SEOutStock truncate table PORFQ truncate table ICMO truncate table ICSale truncate table t_Voucher truncate table t_Voucherentry truncate table ICStockBill truncate table ICStockBillEntry truncate table ICPlanAdjPriEntry truncate table POrequestEntry truncate table POOrderEntry truncate table POInstockEntry truncate table ICPurchaseEntry truncate table ICSaleEntry truncate table SEOrderEntry truncate table SEOutStockEntry truncate table PORFQEntry truncate table ppbom truncate table ICSTJGBill truncate table ICSTJGBillEntry truncate table POInventory truncate table ICChange truncate table ICChangeEntry truncate table ICMOChange truncate table ICMOChangeEntry truncate table PPBomChange truncate table PPBomChangeEntry truncate table PPBOMEntry truncate table ICitemScrap truncate table ICitemScrapEntry truncate table ICMORpt truncate table ICMORptEntry truncate table QMReject truncate table QMRejectEntry truncate table ICMOConvertBill truncate table ICMOConvertBillEntry truncate table icinventory truncate table icbal truncate table icinvbal truncate table ICInvInitial truncate table ICShop_ItemConsumeEntry truncate table CBStdStdPrice truncate table ICQCBillEntry truncate table cbMaterielInfo_History truncate table ICMnbomChild truncate table POInvBal truncate table ICClassCheckRecords1001000 truncate table icstockbillentry2019011501 truncate table icstockbillentry20181120 truncate table ICQuotePriceMtrl truncate table CRM_SVTrace truncate table t_msgList truncate table cbCalinfoDetail truncate table ICBOMChild truncate table ICPrintCountEntry truncate table ICClassCheckStatus1001000 truncate table ICPrintCount truncate table t_CashFlowBal truncate table ICMrpResult truncate table t_MakeVouchTemp truncate table t_BaseProperty truncate table ICClassMCRecord1000040 truncate table ICClassMCStatus1000040 truncate table t_ProfitAndLoss truncate table t_ICItemCore truncate table t_ICItemPlan truncate table t_ICItemQuality truncate table t_ICItemCustom truncate table t_ICItemMaterial truncate table t_ICItemBase truncate table t_ICItemDesign truncate table t_ICItemStandard truncate table t_LowestBomCode truncate table CRM_SVAssign truncate table CRM_ServiceRequest truncate table CRM_Satisfaction truncate table CRM_SVProcess truncate table cbCostObjDetail truncate table ICVouchBillTranType truncate table ICClassCheckRecords1001001 truncate table t_SupplyEntry truncate table t_Supply truncate table cbExpenseDistributeInfo_History truncate table ICShop_ItemConsume truncate table ICClassTableInfo_bak20080418194131 truncate table seorderentry20190624 truncate table seorderentry20190516 truncate table SEOutStockEntry20190624 truncate table ICClassCheckStatus1001001 truncate table CRM_Fittings truncate table cbProductCalInfo truncate table cbCalInfo truncate table CRM_Contact truncate table t_ItemDetailV truncate table t_ItemDetail truncate table ICMrpInfo truncate table t_Balance delete icstockcheckprocess delete icinvbackup DELETE FROM t_Item WHERE FItemID >=135 DELETE FROM t_Base_Emp WHERE FItemID >0 truncate table cb_CostObj_Product truncate table cb_ICStockBill truncate table cb_ICStockBillEntry truncate table cbBalance truncate table CBCalInfo_CurData truncate table CBCalInfoDetail_CurData truncate table cbCompleteQty DELETE cbCostObj WHERE FItemID NOT IN (55,56) truncate table CBCostObjAdjustDetailbak truncate table cbExpenseDistributeInfo truncate table cbInQty truncate table cbMaterielInfo truncate table cbProductQty truncate table cn_Bill truncate table ICbal_sean2 truncate table ICBOM truncate table ICClientVer truncate table ICPlan_PMCDetail truncate table ICPlanOrderRel DELETE FROM t_Account truncate table t_Department truncate table t_dev_AZ truncate table t_dev_AZEntry2 truncate table t_dev_AZSQ truncate table t_dev_AZSQEntry2 truncate table t_dev_AZZF truncate table t_dev_AZZFEntry2 truncate table t_dev_freight truncate table t_dev_freightEntry2 truncate table t_dev_TC truncate table t_dev_TCEntry2 truncate table t_dev_TCPay truncate table t_dev_TCPayEntry2 truncate table t_dev_ZX truncate table t_dev_ZXEntry2 truncate table t_dev_ZXSQ truncate table t_dev_ZXSQEntry2 truncate table t_dev_ZXZF truncate table t_dev_ZXZFEntry2 truncate table t_LockStock truncate table t_Organization truncate table t_Stock truncate table t_Supplier DELETE FROM ICHookRelations DELETE FROM cbWMaterielInfo DELETE FROM cbWCalinfoDetail DELETE FROM cbCostObjCheck DELETE FROM ICQuotePrice DELETE FROM cbWasterCostObjInfo DELETE FROM cbCostVoucher DELETE FROM CBCostExpenseInfo DELETE FROM ICSubContract DELETE FROM dbo.ICSubContractEntry DELETE FROM ICSerialFlow --ÉèÖà ÆôÓÃÆڼ䣬µ±Ç°ÆÚ¼ä,ÕâÀＸÔ·ݿªÊ¼ÓþÍÉèÖÃΪ¼¸ÔÂ·Ý update t_SystemProfile set FValue=9 where FCategory='gl' and FKey='startperiod' update t_SystemProfile set FValue=2020 where FCategory='gl' and FKey='startyear' update t_SystemProfile set FValue=9 where FCategory='ic' and FKey='startperiod' update t_SystemProfile set FValue=2020 where FCategory='ic' and FKey='startyear' update t_SystemProfile set FValue=9 where FCategory='CB' and FKey='startperiod' update t_SystemProfile set FValue=2020 where FCategory='CB' and FKey='startyear' update t_SystemProfile set FValue=9 where FCategory='FA' and FKey='startperiod' update t_SystemProfile set FValue=2020 where FCategory='FA' and FKey='startyear' update t_SystemProfile set FValue=9 where FCategory='gl' and FKey='currentperiod' update t_SystemProfile set FValue=2020 where FCategory='gl' and FKey='currentyear' update t_SystemProfile set FValue=9 where FCategory='ic' and FKey='currentperiod' update t_SystemProfile set FValue=2020 where FCategory='ic' and FKey='currentyear' update t_SystemProfile set FValue=9 where FCategory='CB' and FKey='currentperiod' update t_SystemProfile set FValue=2020 where FCategory='CB' and FKey='currentyear' update t_SystemProfile set FValue=9 where FCategory='FA' and FKey='currentperiod' update t_SystemProfile set FValue=2020 where FCategory='FA' and FKey='currentyear' UPDATE dbo.t_RP_SystemProfile set FValue=9 WHERE FKey ='FAPCurPeriod' UPDATE dbo.t_RP_SystemProfile set FValue=2020 WHERE FKey ='FAPCurYear' UPDATE dbo.t_RP_SystemProfile set FValue=9 WHERE FKey ='FAPUsePeriod' UPDATE dbo.t_RP_SystemProfile set FValue=2020 WHERE FKey ='FAPUseYear' UPDATE dbo.t_RP_SystemProfile set FValue=9 WHERE FKey ='FARCurPeriod' UPDATE dbo.t_RP_SystemProfile set FValue=2020 WHERE FKey ='FARCurYear' UPDATE dbo.t_RP_SystemProfile set FValue=9 WHERE FKey ='FARUsePeriod' UPDATE dbo.t_RP_SystemProfile set FValue=2020 WHERE FKey ='FARUseYear' --Öؽ¨Ë÷Òý DECLARE @DBCCString NVARCHAR(1000) DECLARE @TableName VARCHAR(100) DECLARE Cur_Index CURSOR FOR SELECT Name AS TblName FROM sysobjects WHERE xType='U' ORDER BY TblName FOR READ ONLY OPEN Cur_Index FETCH NEXT FROM Cur_Index INTO @TableName WHILE @@FETCH_STATUS=0 BEGIN PRINT 'Öؽ¨±í' + @TableName +'µÄË÷Òý........Start!' SET @DBCCString = 'DBCC DBREINDEX(@TblName,'''')WITH NO_INFOMSGS' EXEC SP_EXECUTESQL @DBCCString, N'@TblName VARCHAR(100)', @TableName PRINT 'Öؽ¨±í' + @TableName +'µÄË÷Òý........END!' FETCH NEXT FROM Cur_Index INTO @TableName END CLOSE Cur_Index DEALLOCATE Cur_Index PRINT '²Ù×÷Íê³É£¡' --ÊÕËõÊý¾Ý¿â DELETE FROM t_SuspendWorkPushMain DELETE FROM t_SuspendWorkPushDetail DELETE FROM ICClassMCTaskCenter