清空特殊符号

admin

1. update bi_t_item_info set item_name = REPLACE(item_name,CHAR(10),'') where CHARINDEX(CHAR(10),item_name) > 0
   
2. update bi_t_item_info set item_name = REPLACE(item_name,CHAR(9),'') where CHARINDEX(CHAR(9),item_name) > 0
   
3. update bi_t_item_info set item_name = REPLACE(item_name,CHAR(13),'') where CHARINDEX(CHAR(13),item_name) > 0
   
4. 
   
5. update bi_t_item_info set barcode = REPLACE(barcode,CHAR(10),'') where CHARINDEX(CHAR(10),barcode) > 0
   
6. update bi_t_item_info set barcode = REPLACE(barcode,CHAR(9),'') where CHARINDEX(CHAR(9),barcode) > 0
   
7. update bi_t_item_info set barcode = REPLACE(barcode,CHAR(13),'') where CHARINDEX(CHAR(13),barcode) > 0
   
8. 
   
9. update bi_t_item_info set item_subno = REPLACE(item_subno,CHAR(10),'') where CHARINDEX(CHAR(10),item_subno) > 0
   
10. update bi_t_item_info set item_subno = REPLACE(item_subno,CHAR(9),'') where CHARINDEX(CHAR(9),item_subno) > 0
    
11. update bi_t_item_info set item_subno = REPLACE(item_subno,CHAR(13),'') where CHARINDEX(CHAR(13),item_subno) > 0
    
12. 
    
13. update bi_t_item_smbarcode set barcode = REPLACE(barcode,CHAR(10),'') where CHARINDEX(CHAR(10),barcode) > 0
    
14. update bi_t_item_smbarcode set barcode = REPLACE(barcode,CHAR(9),'') where CHARINDEX(CHAR(9),barcode) > 0
    
15. update bi_t_item_smbarcode set barcode = REPLACE(barcode,CHAR(13),'') where CHARINDEX(CHAR(13),barcode) > 0
    
16. 
    
17. select  card_inid,*  from pos_t_vip_info where card_id='0008500'
    
18. select  *  from pos_t_vip_flow where card_id='0000005'
    
19. select  *  from pos_t_vip_info_more where card_id='0000005'
    
20. 
    
21. update pos_t_vip_info set card_id = REPLACE(card_id,CHAR(9),'') where CHARINDEX(CHAR(9),card_id) > 0
    
22. update pos_t_vip_info set card_inid = REPLACE(card_inid,CHAR(9),'') where CHARINDEX(CHAR(9),card_inid) > 0
    
23. update pos_t_vip_flow set card_id = REPLACE(card_id,CHAR(9),'') where CHARINDEX(CHAR(9),card_id) > 0
    
24. update pos_t_vip_info_more set card_id = REPLACE(card_id,CHAR(9),'') where CHARINDEX(CHAR(9),card_id) > 0

复制代码