錯了,改下 Update N_nwes Set NFILE=Replace(NFILE,'/NEWS/','/shtml/')
update N_nwes set NFILE=replace(NFILE,'NEWS','shtml')
update N_nwes set NFILE=replace(a.NFILE,'NEWS','shtml ') from N_nwes a
如果你只是想將//中間的NEWS替換為shtml 最好用 Update N_nwes Set NFILE=Replace(NFILE,'/NEWS/','/shtml/')以防止將別的地方有NEWS的也被更新了。但是,如果你是想將所有的NEWS更新為shtml就用 Update N_nwes Set NFILE=Replace(NFILE,'NEWS','shtml')
Update N_nwes Set NFILE=Replace(NFILE,'/NEWS/','/shtml/')
set NFILE=replace(a.NFILE,'NEWS','shtml ')
from N_nwes a
如果你只是想將//中間的NEWS替換為shtml 最好用
Update N_nwes Set NFILE=Replace(NFILE,'/NEWS/','/shtml/')以防止將別的地方有NEWS的也被更新了。但是,如果你是想將所有的NEWS更新為shtml就用
Update N_nwes Set NFILE=Replace(NFILE,'NEWS','shtml')