SQL 中 replace 替换字符串中的字符 '' 

update  CfmRcd 
   set 
    reconsource=replace(reconsource,'''',''),
    cmffile =replace(cmffile,'''',''),
    cfmdate=replace(cfmdate,'''',''),

'20170721'

 

posted @ 2017-07-21 09:51  蜜雪粮液  阅读(1064)  评论(0)    收藏  举报