数据库挂马修复语句
发布时间：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
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
（免责声明：文章内容如涉及作品内容、版权和其它问题，请及时与我们联系，我们将在第一时间删除内容，文章内容仅供参考）
相关知识
软件推荐
更多 >
-
1菜鸟简单抓肉鸡（如何抓肉鸡）
2011-06-17
-
2
电脑开机时出现lass.exe进程是病毒吗？
-
3
自拍须谨慎！教你如何通过照片定位查看拍摄地点
-
4
电脑病毒最基础知识
-
5
黑客学员必须了解的C语言技术
-
6
精典详细内网渗透专题文章
-
7
教你破解Tp-Link的无线路由密码
-
8
解决SecureCRT中文显示乱码
-
9
QQ电脑管家和360哪个好？横评实测对比
-
10
攻防实战：无线网络路由入侵过程
