Replace 在动态sql中的实现

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

exec sp_executesql @statReplace=@stsqlReplace;

 

转载于:https://www.cnblogs.com/Warmsunshine/p/7235552.html