replace替换字段为text或者ntext时,必须转换类型后才能替换 update news_info set news_content=replace(cast(news_content as varchar(8000)),'/uploadfile/','/newsImages/')