-- ¶©µ¥ truncate table POOrder truncate table dbo.POOrderEntry truncate table dbo.ICSubContract truncate table dbo.ICSubContractEntry truncate table dbo.POInStock truncate table dbo.POInStockEntry --¸¶¿îÉêÇëµ¥ TRUNCATE TABLE t_rp_PayApplyBillEntry TRUNCATE TABLE t_rp_PayApplyBill --²É¹º·¢Æ± truncate table dbo.ICPurchase truncate table dbo.ICPurchaseEntry DELETE FROM dbo.t_RP_Contact WHERE FType =4 --¿â´æÀàµÄµ¥¾Ý¶¼ÔÚÒ»ÕÅ±í£¬É¾³ýËùÓÐ¿â´æµ¥¾Ýºó£¬ÐèҪɾ³ý´æ»õºËËãÓà¶î±íºÍ¼´Ê±¿â´æ±í ALTER TABLE ICStockBill DISABLE TRIGGER ALL DELETE FROM dbo.ICStockBill DELETE FROM dbo.ICStockBillEntry ALTER TABLE ICStockBill ENABLE TRIGGER ALL TRUNCATE TABLE dbo.ICBal TRUNCATE TABLE dbo.ICInvBal TRUNCATE TABLE dbo.ICInventory TRUNCATE TABLE ICInvInitial TRUNCATE TABLE POInvBal TRUNCATE TABLE dbo.POInventory --ÐèÈ«²¿É¾³ýºó£¬Ðè¸üÐÂÆôÓÃÆÚ¼äºóÕËÌײÅÄÜ¿ªÊ¼Ê¹ÓÃ