Replace 在动态sql中的实现

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

exec sp_executesql @statReplace=@stsqlReplace;