可用
update #t set a=replace(cast(a as varchar(50)),cast('http://sohu'as varchar(50)),'http://www.sohu.com') where b=1
转载于:https://www.cnblogs.com/xnxqs/archive/2005/03/16/119667.html
转载于:https://www.cnblogs.com/xnxqs/archive/2005/03/16/119667.html