使用方法 ： 保存为 asptools.hta 然后再运行
代码如下:
<! Doctype html public "-// w3c // dtd xhtml 1.0 transitional // en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-
transitional.dtd ">
<html xmlns = "http://www.w3.org/1999/xhtml">
<Evista>
<meta http-equiv = "content-type" content = "text /html; charset = gb2312" />
<meta name = "autor" content = "柳永法" />
<title> ASP 辅助工具 </title>
<style> Body {Font-Size: 12px} </style>
<HTA: aplicación
Id = "aspTools"
ApplicationName = "AspTools"
Scroll = "No"
SingleInstance = "Sí"
WindowState = "Normal"
>
</ablo>
<Body>
<div>
<input type = "file" id = "txtfile" onchange = "createTableSelect ('access')" style = "Display: None" />
IP: <input type = "text" name = "ip" size = "16" style = "border: 1px sólido verde" valor = "./ sql2005" />
登录名 ： <input type = "text" name = "userId" size = "10" style = "border: 1px sólido verde" value = "sa" />
密码 ： <input type = "contraseña" name = "pwd" size = "10" style = "border: 1px sólido verde" value = "yongfa365" />
数据库名: <input type = "text" name = "dbname" size = "10" style = "border: 1px sólido verde" value = "hb605-8-8" /> <br />>
<input name = "button2" type = "button" id = "button2" style = "border: 1px sólido verde" onClick = "CreateTableLect
('Mssql') "valor =" 连接 sql 数据库 " />
<input type = "botón" id = "btnFromFile" onClick = "txtfile.click ()" value = "连接 access 数据库" style = "borde: 1px sólido
verde " />
<span id = "Tablas"> </span>
<hr />
模板 ：
<input type = "text" id = "opt" value = "" size = "40" />
<select size = "1" id = "fz" onchange = "opt.value = this.value"> </elect>
<input name = "Button" type = "button" id = "botón" onClick = "c ()" value = "转换" style = "border: 1px sólido verde">
<hr />
<Textarea id = "S" ROWS = "10" cols = "80"> </extarea>
<input type = "button" onClick = "Madesql ()" value = "生成 sql 语句" style = "border: 1px sólido verde" />
<Textarea id = "D" Rows = "10" cols = "80"> </extarea>
</div>
<pre id = "sqldemo" style = "display: none" intro = "通用建表结构">
-通用建表结构
Crear tabla [DBO]. [TableName] (
[Id] int primaria identidad de clave (1,1),-id ， ， 自动号
[txttitle] varchar (255),-标题
[txtcontent] texto,-内容
[PutTime] DateTime Default (getDate ()),-提交时间
[Moditime] DateTime Default (getDate ()),-修改时间
[Hits] int predeterminado (0),-点击数
[FLAGS] INT default (0),-标识
[OrderId] int predeterminado (0),-排序号
)
</pre>
<pre id = "sdemo" style = "display: none" intro = "初始源测试数据">