📄 access to sql 脚本编写器.htm
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0054)http://www.blueidea.com/download/product/2004/2329.asp -->
<HTML><HEAD><TITLE>蓝色理想 - Access to Sql 脚本编写器</TITLE>
<META content="" name=keywords>
<META content="2004-11-13 17:06:31" name=publishDate>
<META content="2004-11-21 0:37:05" name=updateDate>
<META content="2004-11-22 0:12:23" name=generatDate>
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<META content=www.blueidea.com name=Author>
<META http-equiv=Content-Type content="text/html; charset=gb2312"><LINK
href="Access to Sql 脚本编写器.files/style.css" type=text/css rel=stylesheet>
<SCRIPT language=JavaScript
src="Access to Sql 脚本编写器.files/adbanner.js"></SCRIPT>
<SCRIPT language=JavaScript
src="Access to Sql 脚本编写器.files/colorsetting.js"></SCRIPT>
</HEAD>
<BODY>
<TABLE class=border cellSpacing=6 cellPadding=0 width=778 border=0>
<TBODY>
<TR>
<TD class=logoBackground align=middle width=101><A
href="http://www.blueidea.com/"><IMG height=27
src="Access to Sql 脚本编写器.files/logo.gif" width=90 border=0></A> </TD>
<TD vAlign=top width=659>
<TABLE height=31 cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR vAlign=top>
<TD>
<TABLE class=navDark cellSpacing=6 cellPadding=0 width="100%"
border=0>
<TBODY>
<TR>
<TD align=middle><A class=navLink
href="http://www.blueidea.com/news/index.asp">业界动态</A></TD></TR></TBODY></TABLE></TD>
<TD width=6><IMG height=6 src="Access to Sql 脚本编写器.files/spacer.gif"
width=6></TD>
<TD>
<TABLE class=navDark cellSpacing=6 cellPadding=0 width="100%"
border=0>
<TBODY>
<TR>
<TD align=middle><A class=navLink
href="http://www.blueidea.com/tech/index.asp">技术文档</A></TD></TR></TBODY></TABLE></TD>
<TD width=6><IMG height=6 src="Access to Sql 脚本编写器.files/spacer.gif"
width=6></TD>
<TD>
<TABLE class=navDark cellSpacing=6 cellPadding=0 width="100%"
border=0>
<TBODY>
<TR>
<TD align=middle><A class=navLink
href="http://www.blueidea.com/design/index.asp">艺术设计</A></TD></TR></TBODY></TABLE></TD>
<TD width=6><IMG height=6 src="Access to Sql 脚本编写器.files/spacer.gif"
width=6></TD>
<TD>
<TABLE class=navDark cellSpacing=6 cellPadding=0 width="100%"
border=0>
<TBODY>
<TR>
<TD align=middle><A class=navLink
href="http://www.blueidea.com/photo/index.asp">摄影摄像</A></TD></TR></TBODY></TABLE></TD>
<TD width=6><IMG height=6 src="Access to Sql 脚本编写器.files/spacer.gif"
width=6></TD>
<TD>
<TABLE class=navDark cellSpacing=6 cellPadding=0 width="100%"
border=0>
<TBODY>
<TR>
<TD align=middle><A class=navLink
href="http://www.blueidea.com/computer/index.asp">计算机技术</A></TD></TR></TBODY></TABLE></TD>
<TD width=6><IMG height=6 src="Access to Sql 脚本编写器.files/spacer.gif"
width=6></TD>
<TD class=navLight>
<TABLE cellSpacing=6 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD align=middle><B><A class=navLink
href="http://www.blueidea.com/download/index.asp">资源下载</A></B></TD></TR></TBODY></TABLE></TD>
<TD width=6><IMG height=6 src="Access to Sql 脚本编写器.files/spacer.gif"
width=6></TD>
<TD>
<TABLE class=navDark cellSpacing=6 cellPadding=0 width="100%"
border=0>
<TBODY>
<TR>
<TD align=middle><A class=navLink
href="http://www.blueidea.com/column/index.asp">个人专栏</A></TD></TR></TBODY></TABLE></TD>
<TD width=6><IMG height=6 src="Access to Sql 脚本编写器.files/spacer.gif"
width=6></TD>
<TD>
<TABLE class=navDark cellSpacing=6 cellPadding=0 width="100%"
border=0>
<TBODY>
<TR>
<TD align=middle><A class=navLink
href="http://www.blueidea.com/cg/index.asp">CG绘画</A></TD></TR></TBODY></TABLE></TD>
<TD width=6><IMG height=6 src="Access to Sql 脚本编写器.files/spacer.gif"
width=6></TD>
<TD>
<TABLE class=navDark cellSpacing=6 cellPadding=0 width="100%"
border=0>
<TBODY>
<TR>
<TD align=middle><A class=navLink
href="http://www.blueidea.com/bbs">经典论坛</A></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE class=navLight cellSpacing=6 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD><FONT color=#ffffff><A class=navLink
href="http://www.blueidea.com/download/site/index.asp">网页快照</A> |
·<A class=navLink
href="http://www.blueidea.com/download/product/index.asp"><B>经典产品</B></A>
</FONT></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE class=border cellSpacing=0 cellPadding=0 width=778 border=0>
<TBODY>
<TR>
<TD align=middle height=10>
<TABLE class=pageSeparator cellSpacing=6 cellPadding=0 width=766
border=0><TBODY>
<TR>
<TD height=10><SPAN class=location>您的位置： <A
href="http://www.blueidea.com/index.asp">首页</A> > <A
href="http://www.blueidea.com/download/index.asp">资源下载</A> > <A
href="http://www.blueidea.com/download/product/index.asp">经典产品</A>
> Access to Sql 脚本编写器</SPAN></TD>
<TD align=right>
<SCRIPT language=JavaScript
src="Access to Sql 脚本编写器.files/color.js"></SCRIPT>
</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE class=border cellSpacing=6 cellPadding=0 width=778 border=0>
<TBODY>
<TR>
<TD class=pageLight vAlign=top align=middle width=540>
<SCRIPT language=JavaScript>showbanner(2,2);</SCRIPT>
<TABLE class=border cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD align=middle><IMG height=6
src="Access to Sql 脚本编写器.files/spacer.gif"
width=6></TD></TR></TBODY></TABLE>
<TABLE class=pageIcon cellSpacing=0 cellPadding=1 width="100%" border=0>
<TBODY>
<TR>
<TD width=227></TD>
<TD align=middle width=80><IMG height=15
src="Access to Sql 脚本编写器.files/list.gif" width=15 align=absMiddle>
<A href="http://www.blueidea.com/download/product/"><FONT
color=#999999>回到列表</FONT></A></TD>
<TD align=right width=227><IMG height=15
src="Access to Sql 脚本编写器.files/next.gif" width=15 align=absMiddle>
<A
href="http://www.blueidea.com/download/product/2004/2247.asp">第一届简历样式表设计作品下载</A>
</TD></TR></TBODY></TABLE></TD>
<TD class=listcontent vAlign=top align=middle width=220>
<TABLE cellSpacing=6 cellPadding=0 width="100%" border=0>
<FORM name=Authorize action=/bbs/login.asp method=post><INPUT
type=hidden value=/bbs name=ForwardUrl2>
<TBODY>
<TR>
<TD>用户名：</TD>
<TD align=middle><INPUT class=homeLoginInput
onblur=javascript:document.Authorize.password.focus();
style="WIDTH: 65px" size=4 name=username> </TD>
<TD align=right><INPUT type=image height=19 width=40
src="Access to Sql 脚本编写器.files/loginbutton.gif" border=0
name=imageField2> </TD></TR>
<TR>
<TD>密 码：</TD>
<TD align=middle><INPUT class=homeLoginInput style="WIDTH: 65px"
type=password size=4 name=password> </TD>
<TD align=right><A
href="http://www.blueidea.com/bbs/ubbmisc.asp?action=lostpw">忘记密码</A></TD></TR>
<TR>
<TD vAlign=bottom height=18><A
href="http://www.blueidea.com/bbs/signup.asp">注册会员</A></TD>
<TD vAlign=bottom align=middle><A
href="http://www.blueidea.com/bbs">游客参观</A></TD>
<TD vAlign=bottom align=right><A
href="http://www.blueidea.com/news/site/2003/339.asp">论坛帮助</A></TD></TR></FORM></TBODY></TABLE>
<SCRIPT language=JavaScript>showbanner(4,4);</SCRIPT>
</TD></TR></TBODY></TABLE>
<TABLE class=border cellSpacing=0 cellPadding=0 width=778 border=0>
<TBODY>
<TR>
<TD align=middle>
<TABLE class=pageSeparator cellSpacing=0 cellPadding=0 width=766
border=0><TBODY>
<TR>
<TD align=middle><IMG height=12
src="Access to Sql 脚本编写器.files/spacer.gif" width=12><!--<SCRIPT language=JavaScript>showbanner(6,6);</SCRIPT>--></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE class=border cellSpacing=6 cellPadding=0 width=778 border=0>
<TBODY>
<TR>
<TD class=pagelighter vAlign=top width=540>
<TABLE class=listtitle cellSpacing=0 cellPadding=1 width="100%"
border=0><TBODY>
<TR>
<TD>
<TABLE class=pageSubject cellSpacing=6 cellPadding=0 width="100%"
border=0>
<TBODY>
<TR>
<TD class=content><STRONG> Access to Sql
脚本编写器</STRONG></TD></TR></TBODY></TABLE>
<TABLE class=docParameter cellSpacing=6 cellPadding=0 width="100%"
border=0>
<TBODY>
<TR>
<TD>
<P>作者：V37 时间：2004-11-13 文档类型：<AC:DOCTYPE /> 来自：<A
href="http://www.blueidea.com/" target=_blank>蓝色理想</A><BR>浏览统计
year:3412 | Quarter:3412 | Month:991 | Week:539 | today:24</P>
<P class=list></P></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE class=border cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD><IMG height=6 src="Access to Sql 脚本编写器.files/spacer.gif"
width=6></TD></TR></TBODY></TABLE>
<TABLE class=pageLighter cellSpacing=11 cellPadding=0 width="100%"
border=0>
<TBODY>
<TR>
<TD class=content>
<P>更新第五版（Access可以直接导入SQLserver）：<BR>修正一些bug,用多个目前流行的Access整站和论坛数据库测试（测试最大的80M数据库）<BR>Exe版本可以直接导入到SQL数据库，下载包含Asp
和Exe两个版本的文件<BR> <A
href="http://www.paintblue.net/download/data/DB_CreateSqlEV1.05.rar"><BR></A>下载：<A
class=""
href="http://www.blueidea.com/articleimg/2004/11/2329/DB_CreateSqlEV1.05.rar"
target=_blank>DB_CreateSqlEV1.05.rar</A></P>
<P><A class=""
href="http://www.blueidea.com/articleimg/2004/11/2329/demo_5.png"
target=_blank><IMG height=392 alt=""
src="Access to Sql 脚本编写器.files/demo_5-1.png" width=510
border=0></A></P>
<P>更新第三版：<BR>可以生成完全创建新的SQL库和登陆，并且导入数据的sql和 asp脚本</P>
<P><A
href="http://www.paintblue.net/download/data/DB_CreateSqlE(B2004-11-18).rar"><A
class=""
href="http://www.blueidea.com/articleimg/2004/11/2329/DB_CreateSqlE(B2004-11-18).rar"
target=_blank>下载：DB_CreateSqlE(B2004-11-18).rar</A></P>
<P>------------------------------------------------------<BR>增加第二版的
VB重写的编译Exe版本（可以成为一个小工具）,摆脱asp代码运行的不方便！</P>
<P>下载：<A
href="http://www.paintblue.net/download/data/MDB_CreateSQLE.rar"><A
class=""
href="http://www.blueidea.com/articleimg/2004/11/2329/MDB_CreateSQLE.rar"
target=_blank>MDB_CreateSQLE.rar</A></P>
<P>------------------------------------------------------<BR>Asp版本<BR>下载:
<BR><B>第一版</B>(生成在Access下运行的SQL和Asp):</P>
<P>下载：<A class=""
href="http://www.blueidea.com/articleimg/2004/11/2329/DB_CreateSql.rar"
target=_blank>DB_CreateSql.rar</A></P>
<P><B>第二版</B>(生成Access数据升迁导入到SQLserver的
Sql脚本<BR>生成结果需要在SQLserver的查询分析器里运行，使用到dataopensource()函数):</P>
<P>下载：<A class=""
href="http://www.blueidea.com/articleimg/2004/11/2329/DB_CreateSqlE.rar"
target=_blank>DB_CreateSqlE.rar</A> </P>
<P>sql和access的脚本语法细节不一样，所以这两个版本是的结果是完全不同的<BR>第二个版本可能更实用</P>
<P align=center><IMG height=477 alt=""
src="Access to Sql 脚本编写器.files/db_create.png" width=486
border=0></P>
<P><STRONG>出发点</STRONG></P>
<P>因为做数据库升级程序,牵涉到建表,建索引,约束,默认啊!表关系的!!!
晕啊!!!!!<BR>全新写生成数据库结构的Sql语句实在无比麻烦!</P>
<P>最好的需要是,在Access里弄好表结构设计,然后像Sql2000那样对数据库对象编写Sql脚本,基于这个处发点,所以编写了这个小程序,专门对Access数据库对象编写Sql脚本，起到事半功倍的作用!
方便方便</P>
<P><STRONG>功能简介</STRONG> <BR>功能:可编写Access数据库的常用的主要对象,包括
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -