declare @pos int
declare @len int
declare @str nvarchar(4000)
declare @des nvarchar(4000)
declare @count int
set @des ='<requested_amount+1>'
set @len=len(@des)
set @str= '<requested_amount>'
set @count=0--统计次数.
WHILE 1=1
BEGIN
select @pos=patINDEX('%'+@des+'%',column_name) - 1
from tbl_name
where id=2093
IF @pos>=0
begin
DECLARE @ptrval binary(16)
SELECT @ptrval = TEXTPTR(column_name)
from tbl_name
where id=2093
UPDATETEXT tbl_name.column_name @ptrval @pos @len @str
set @count=@count+1
end
ELSE
break;
END