奇哉怪也， 存储过程执行成功，数据却没有变化

[helloha2013]

存储过程如下，意在更新数据库中超过8000个字符的ntext字段skinmain的值：

CREATE PROC dbo.SearchAndReplace
(
@FindString NVARCHAR(100)
,@ReplaceString NVARCHAR(100)
)
AS
BEGIN
SET NOCOUNT ON

DECLARE @TextPointer VARBINARY(16)
DECLARE @DeleteLength INT
DECLARE @OffSet INT

SELECT @TextPointer = TEXTPTR([skinmain])
FROM [userskin]

SET @DeleteLength = LEN(@FindString)
SET @OffSet = 0
SET @FindString = '%' + @FindString + '%'

WHILE (SELECT COUNT(*)
FROM [userskin]
WHERE CHARINDEX(@FindString, [skinmain]) <> 0) > 0
BEGIN
SELECT @OffSet = CHARINDEX(@FindString, [skinmain]) - 1
FROM [userskin]
WHERE CHARINDEX(@FindString, [skinmain]) <> 0

UPDATETEXT [userskin].[skinmain]
@TextPointer
@OffSet
@DeleteLength
@ReplaceString
END

SET NOCOUNT OFF
END
GO


查询分析器中执行 SearchAndReplace "http://127.0.0.1","/"
提示“命令已成功完成"

然后我再SELECT COUNT(*) AS Expr1
FROM userskin
WHERE (skinmain LIKE '%127.0.0.1%')

仍然返回原来的68条

[virgo2008]

额！奇怪的事情还真多！

[helloha2013]

好像是 SELECT @OffSet = CHARINDEX(@FindString, [skinmain]) - 1
FROM [userskin]
WHERE CHARINDEX(@FindString, [skinmain]) <> 0
只提了最后一条记录，

但不知道怎么修改？