declare @s_str varchar(8000),@d_str varchar(8000)
select @s_str='src="/images/' --要替换的字符串
,@d_str='src="/image/' --替换成的字符串
--定义游标,循环处理数据
declare @id int
declare #tb cursor for select ppublishid from ppublishinfo
open #tb
fetch next from #tb into @id
while @@fetch_status=0
begin
--字符串替换处理
declare @p varbinary(16),@postion int,@rplen int
select @p=textptr(ppublishtext),@rplen=len(@s_str),@postion=charindex(@s_str,ppublishtext)-1 from ppublishinfo where ppublishid=@id
while @postion>0
begin
updatetext ppublishinfo.ppublishtext @p @postion @rplen @d_str
select @postion=charindex(@s_str,ppublishtext)-1 from ppublishinfo where ppublishid=@id
end
fetch next from #tb into @id
end
close #tb
deallocate #tb
替换字段值
最新推荐文章于 2023-09-20 17:16:51 发布