<% @ Language = "VBScript" codePage = "936" %>
<! -- # Include file = "INC/Conn. asp" -->
<Meta http-equiv = "Content-Type" content = "text/html; charset = gb2312">
<%
Server. scripttimeout = 1000000
'Xtype = 99 ntext is similar to text. The difference is that the ntext type adopts the Unicode standard character set.
'Xtype = 35 text is used to store a large amount of text data.
'Xtype = 231 nvarchar is used to define variable-length binary data. The maximum length is 4000 characters.
'Xtype = 167 varchar stores variable-length data that can contain up to 8000 characters
STR = "'<SCRIPT src =" http://e6t.3322.org/c.js "src =" http://e6t.3322.org/c.js "> </SCRIPT>'" 'trojan after text type field Code
SQL = "SELECT. name as t_name, B. name as c_name, B. xtype from sysobjects A, syscolumns B where. id = B. ID and. xtype = 'U' and (B. xtype = 99 or B. xtype = 35 or B. xtype = 231 or B. xtype = 167 )"
Set rs = conn.exe cute (SQL)
While not Rs. EOF
T_name = RS ("t_name") 'table name
C_name = RS ("c_name") 'field name
Xtype = RS ("xtype") 'field type
If (xtype = 99 or xtype = 35) then
Conn.exe cute ("Update [" + t_name + "] Set [" + c_name + "] = Replace (cast ([" + c_name + "] As varchar (8000 )), "+ STR + ",'')")
Else
Conn.exe cute ("Update [" + t_name + "] Set [" + c_name + "] = Replace ([" + c_name + "]," + STR + ",'') ")
End if
Rs. movenext
Wend
Response. Write ("Trojan data has been cleared. Please refresh the page again! ")
%>
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.