½ðɳ¼¯ÍŹÙÍø:ÓÃÓÑu8Èí¼þÉú³ÉÏúÊÛ³ö¿âµ¥±¨´í
2018-07-02 09:57 À´Ô´£ºÓÃÓÑ
Éú³ÉÏúÊÛ³ö¿âµ¥±¨´íÔÒò·ÖÎö£º¾¼ì²é³ö¿âµ¥µ¥¾ÝºÅ´øÓÐÌØÊâ·ûºÅ¡®-¡¯ºÍ¡®.¡¯ËùÖ£¬ÇëÔÚ²éѯ·ÖÎöÆ÷ÀïÑ¡Ôñ¶ÔÓ¦ÕÊÌ×Ö´ÐÐÏÂÁÐÓï¾ä(×¢Òⱸ·Ý°¡£¡) update rdrecord set ccode=replace(ccode,'-','0') where brdflag=0 and cvouchtype='32' update rdrecord set ccode=replace(ccode,'.','0') where brdflag=0 and cvouchtype='32' ÉÏÊöÁ½ÌõÓï¾ä½«³ö¿âµ¥µ¥¾ÝºÅÖеġ®-¡¯ºÍ¡®.¡¯È«¸Ã³ÉÁË0£¬Óû§¿ÉÒÔ¸ù¾Ýʵ¼ÊÇé¿ö½øÐÐÐ޸ġ£ÎÊÌâ½â´ð£º¾¼ì²é³ö¿âµ¥µ¥¾ÝºÅ´øÓÐÌØÊâ·ûºÅ¡®-¡¯ºÍ¡®.¡¯ËùÖ£¬ÇëÔÚ²éѯ·ÖÎöÆ÷ÀïÑ¡Ôñ¶ÔÓ¦ÕÊÌ×Ö´ÐÐÏÂÁÐÓï¾ä(×¢Òⱸ·Ý°¡£¡) update rdrecord set ccode=replace(ccode,'-','0') where brdflag=0 and cvouchtype='32' update rdrecord set ccode=replace(ccode,'.','0') where brdflag=0 and cvouchtype='32' ÉÏÊöÁ½ÌõÓï¾ä½«³ö¿âµ¥µ¥¾ÝºÅÖеġ®-¡¯ºÍ¡®.¡¯È«¸Ã³ÉÁË0£¬Óû§¿ÉÒÔ¸ù¾Ýʵ¼ÊÇé¿ö½øÐÐÐ޸ġ£