DECLARE @val varbinary(16)
declare @n int
declare @len int
declare @old varchar(8000)
declare @new varchar(8000)
declare @i int
set @i=0
set @old = 'TABLE cellSpacing=0'
set @new = 'TABLE cellSpacing=5'
set @len = len(@old)
while (@i<10)
begin
SELECT top 1 @val = TEXTPTR([content]),@n = patindex('%'+@old+'%',[content])-1
from soft
where id= 151183
if @@rowcount = 0
break
updatetext soft.[content] @val @n @len @new
set @i=@i+1
print @n
end
go
注:textptr:获取某表某字段指针 如select @p=textptr(cont) from soft where id=xxxx;
patindex:被替换内容的位置 patindex('%'+被替换内容+'%')
updatetext:更新字段内容 updatetext 表.字段 指针 位置 长度 替换内容