--ÏúÊÛºÏͬ truncate table t_RPContract truncate table t_RPContractDetail truncate table t_rpContractEntry -- ¶©µ¥ truncate table dbo.SEOrder truncate table dbo.SEOrderEntry --·¢»õ֪ͨ,ÍË»õ֪ͨ truncate table dbo.SEOutStock truncate table dbo.SEOutStockEntry --ÏúÊÛ·¢Æ± truncate table dbo.ICSale truncate table dbo.ICSaleEntry DELETE FROM dbo.t_RP_Contact WHERE FType =3 --ÏúÊÛ³ö¿â£¬¿â´æÀàµÄµ¥¾Ý¶¼ÔÚÒ»ÕÅ±í£¬É¾³ýËùÓÐ¿â´æµ¥¾Ýºó£¬ÐèҪɾ³ý´æ»õºËËãÓà¶î±íºÍ¼´Ê±¿â´æ±í ALTER TABLE ICStockBill DISABLE TRIGGER ALL DELETE FROM dbo.ICStockBill WHERE FTranType IN (21) DELETE FROM dbo.ICStockBillEntry WHERE FInterID NOT IN (SELECT FInterID FROM dbo.ICStockBill) ALTER TABLE ICStockBill ENABLE TRIGGER ALL --ÊÕ¿îµ¥£¬ÓëÓ¦ÊÕϵͳÏà¹Ø£¬ÐèÈ·ÈϺóÔÙɾ³ý£¬É¾³ýºóÐèҪɾ³ýÓà¶î£¬½¨ÒéÓ¦ÊÕÓ¦¸¶Ò»Æð´¦Àí --ÐèÈ«²¿É¾³ýºó£¬Ðè¸üÐÂÆôÓÃÆÚ¼äºóÕËÌײÅÄÜ¿ªÊ¼Ê¹ÓÃ