更新问题,ntext类型如何更新
可用
update #t set a=replace(cast(a as varchar(50)),cast('http://sohu'as varchar(50)),'http://www.sohu.com') where b=1
update #t set a=replace(cast(a as varchar(50)),cast('http://sohu'as varchar(50)),'http://www.sohu.com') where b=1