修改表字段内容批量替换

-- =============================================
-- 修改表字段内容 批量替换
-- =============================================

DECLARE @id int
DECLARE @v1 varchar(8000)

DECLARE C1 CURSOR
FOR SELECT id , Convert(varchar(8000),filed) from tablename where 1=1
FOR UPDATE of C1

OPEN C1
FETCH NEXT FROM C1 INTO @id , @v1

WHILE (@@fetch_status <> -1)
BEGIN
 IF (@@fetch_status <> -2)
 BEGIN
  PRINT @id
  PRINT @v1

  -- 更新替换表内容 a=>b
  -- UPDATE tablename SET v1 = replace(@v1,'a','b') WHERE id = @id
 END
 FETCH NEXT FROM C1 INTO
 SELECT @count = @count + 1
END

CLOSE C1
DEALLOCATE C1
GO