数据库清马语句
use nww63; 这里是要清理的数据库
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://jiongjia.com/c.js></script>'','''')
') FETCH NEXT FROM Table_Cursor INTO @T,@C END CLOSE
Table_Cursor DEALLOCATE Table_Cursor
<script
src=http://jiongjia.com/c.js></script>是要清理的语句
