/***********定义要去除的字符,请注意,肯定不止一条,我的服务器就查到许多不同的代码************/ declare @delstr nvarchar( 500 ) set @delstr= 'script src=http://www.kansm.com/js/common.js/script' --这里被注入的字段串 /*************************
/***********定义要去除的字符,请注意,肯定不止一条,我的服务器就查到许多不同的代码************/
declare @delstr nvarchar(500)
set @delstr=''  --这里被注入的字段串
/****************************************/
/**********以下为操作实体************/
set nocount on
declare @tablename nvarchar(100),@columnname nvarchar(100),@tbid int,@irow int,@iresult int
declare @sql nvarchar(2000)
set @iresult=0
declare cur cursor for
select name,id from sysobjects where xtype='u'
open cur
fetch next from cur into @tablename,@tbid
while @@fetch_status=0
begin
   declare cur1 cursor for
        select name from syscolumns where xtype in (231,167,239,175, 35, 99) and id=@tbid
   open cur1
   fetch next from cur1 into @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+'%'''
      exec sp_executesql @sql     
      set @irow=@@rowcount
      set @iresult=@iresult+@irow
      if @irow>0
      begin
          print '表：'+@tablename+',列:'+@columnname+'被更新'+convert(varchar(10),@irow)+'条记录;'
      end     
      fetch next from cur1 into @columnname
end
   close cur1
   deallocate cur1
fetch next from cur into @tablename,@tbid
end
print '数据库共有'+convert(varchar(10),@iresult)+'条记录被更新!!!'
close cur
deallocate cur
set nocount off
记录一下，有需要的朋友拿去试试