替换字段值

  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