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
替换字段值
最新推荐文章于 2022-10-25 19:38:36 发布