使用方法 ： 保存为 asptools.hta 然后再运行
代码如下:
<!
transitional.dtd ">
<html xmlns = "http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv = "content-type" content = "text /html; charset = gb2312" />
<meta name = "autor" content = "柳永法" />
<title> asp 辅助工具 </title>
<estilo> corpo {font-size: 12px} </style>
<HTA: Aplicação
Id = "Asptools"
ApplicationName = "AsPtools"
Scroll = "não"
SingleInstance = "Sim"
Windowstate = "Normal"
>
</head>
<Body>
<div>
<input type = "file" id = "txtfile" onchange = "createTablesElect ('access')" style = "display: nenhum" />
IP ： <input type = "text" name = "ip" size = "16" style = "borda: 1px verde sólido" value = "./ sql2005" />
登录名 ： <input type = "text" name = "userId" size = "10" style = "borda: 1px verde sólido" value = "sa" />
密码 ： <entrada type = "senha" name = "pwd" size = "10" style = "borda: 1px verde sólido" value = "yongfa365" />
数据库名: <entrada de entrada = "text" name = "dbname" size = "10" style = "borda: 1px verde sólido" value = "hb605-8-8" /> <r />
<input name = "button2" type = "button" id = "button2" style = "borda: 1px verde sólido" onclick = "createTablesElect
('Mssql') "value =" 连接 sql 数据库 " />
<input type = "button" id = "btnfromfile" onclick = "txtfile.click ()" value = "连接 access 数据库" style = "borda: 1px Solid
verde " />
<span id = "tabelas"> </span>
<hr />
模板
<input type = "text" id = "opt" value = "" size = "40" />
<select size = "1" id = "fz" onchange = "opt.value = this.value"> </select>
<input name = "button" type = "button" id = "botão" onclick = "c ()" value = "转换" style = "borda: 1px verde sólido">
<hr />
<texttarea id = "s" linhas = "10" cols = "80"> </sexttarea>
<input type = "button" onclick = "madesql ()" value = "生成 sql 语句" style = "borda: 1px verde sólido" />
<textarea id = "d" linhas = "10" cols = "80"> </sexttarea>
</div>
<pred = "sqldemo" style = "display: nenhum" intro = "通用建表结构">
-通用建表结构
Criar tabela [DBO]. [Nome do tablete] (
[Id] int identidade da chave primária (1,1),-id ， 主键 ， 自动号
[txttitle] Varchar (255),-标题
[txtContent] texto,-内容
[Puttime] DateTime Padrão (getDate ()),-提交时间
[Moditime] DateTime padrão (getDate ()),-修改时间
[Hits] int padrão (0),-点击数
[Sinalizadores] Int padrão (0),-标识
[OrderId] Int padrão (0),-排序号
)
</pre>
<pre iD = "sdemo" style = "display: nenhum" intro = "初始源测试数据">