87,910
社区成员
发帖
与我相关
我的任务
分享
var tc = new ActiveXObject("newObjects.utilctls.TypeConvertor")
var bin = new ActiveXObject("newObjects.utilctls.SFBinaryData")
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("Provider=SQLOLEDB;Data source=127.0.0.1;Initial Catalog=CHANGE;User ID=sa;Password=sa;");
sql = "SELECT data FROM xxx WHERE data IS NOT NULL";
var rs = new ActiveXObject("ADODB.RecordSet");
rs.Open(sql, conn, 1,1);
while(!rs.EOF){
var s = "";
bin.Value = rs(0).Value;
for(var i=0;i<21;i++){
var c = tc.CInt(bin.Byte(i));
s += "" + c.toString(16).toUpperCase();
}
// 输出字段16进制编码
WScript.Echo(s);
rs.MoveNext();
}
rs.Close();
conn.Close();