Replace 在动态sql中的实现

set @stsqlReplace='
    update ChgCfm
   set 
    cfmdate=replace(cfmdate,'''''''',''''),
    cfmstatu=replace(cfmstatu,'''''''','''')    
    ';

exec sp_executesql @statReplace=@stsqlReplace;