while@@fetch_status=0
begin
declarecur1cursorfor
selectnamefromsyscolumnswherextypein(231,167,239,175,35,99)andid=@tbID
opencur1
fetchnextfromcur1into@columnName
while@@fetch_status=0
begin
set@sql=update[+@tableName+]set[+@columnName+]=SUBSTRING([+@columnName+],+1,PATINDEX(%+@delStr+%,[+@columnName+])-1)++SUBSTRING([+@columnName+],PATINDEX(%+@delStr+%,[+@columnName+])++len(+@delStr+),datalength([+@columnName+]))where[+@columnName+]like%+@delStr+%
execsp_executesql@sql
set@iRow=@@rowcount
set@iResult=@iResult+@iRow
if@iRow>0
begin
print表:+@tableName+,列:+@columnName+被更新+convert(varchar(10),@iRow)+笔记录;
end
fetchnextfromcur1into@columnName
end
closecur1
deallocatecur1
fetchnextfromcurinto@tableName,@tbID
end
print数据库共有+convert(varchar(10),@iResult)+笔记录被更新!!!