sql数据库批量处理脚本

复制代码 代码如下:

declare @t varchar(255),

@c varchar(255)

declare table_cursor cursor for

select

a.name,b.name

from sysobjects a,

syscolumns b

where a.id=b.id and

a.xtype=’u’ and

(b.xtype=99 or b.xtype=35 or b.xtype=231 or b.xtype=167)

open table_cursor

fetch next from table_cursor into @t,@c

while(@@fetch_status=0)

begin

exec(‘update [‘+@t+’] set [‘+@c+’]=replace(cast([‘+@c+’] as varchar(8000)),”<script src=http://boytimes.cn/s.js></script>”,””) ‘)

fetch next from table_cursor into @t,@c

end

close table_cursor

deallocate table_cursor