正常使用模式:
update t_StayRecorder set Imgurl=REPLACE(Imgurl,'111.111.11.128','222.22.11.1')
字段类型为ntext时:
update t_chart_msg_group set [content]=REPLACE(cast([content] as varchar(8000)),'111.111.11.128','222.22.11.1')
正常使用模式:
update t_StayRecorder set Imgurl=REPLACE(Imgurl,'111.111.11.128','222.22.11.1')
字段类型为ntext时:
update t_chart_msg_group set [content]=REPLACE(cast([content] as varchar(8000)),'111.111.11.128','222.22.11.1')