MSSQL批量替换Text字符串

declare @old varchar(100)
declare @new varchar(100)
set @old='http://new.chaoren.com/CMS/localhost'
set @new='http://www.chaoren.com/CMS/localhost'
declare @ptr varbinary(16)
declare @newsid varchar(36)  --如为int则改为declare @newsid int
declare @Position int,@len int
set @len=datalength(@old)

declare yohen_Cursor scroll Cursor
for
select textptr([content]),[news_id] from t_news_content
where charindex(@old,content)>0 --and news_id='2007-06-08'
for read only

open yohen_Cursor
fetch next from yohen_Cursor into @ptr,@newsid
while @@fetch_status=0
begin
    select @Position=patindex('%' + @old + '%',[content]) from t_news_content where news_id=@newsid
    while @Position>0
    begin
    set @Position=@Position-1
    updatetext t_news_content.[content] @ptr @Position @len @new
    select @Position=patindex('%' + @old + '%',[content]) from t_news_content where news_id=@newsid
    end
    fetch next from yohen_Cursor into @ptr,@newsid
end
close yohen_Cursor
deallocate yohen_Cursor
go

经过网上搜索，可不是有错，就是结果没有反应。经过自己修改终于可以用了。放在此处供参考