?? 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>藍(lán)色理想 - 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">業(yè)界動(dòng)態(tài)</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">技術(shù)文檔</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">藝術(shù)設(shè)計(jì)</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">計(jì)算機(jī)技術(shù)</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">個(gè)人專欄</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">經(jīng)典論壇</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">網(wǎng)頁快照</A> |
·<A class=navLink
href="http://www.blueidea.com/download/product/index.asp"><B>經(jīng)典產(chǎn)品</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">經(jīng)典產(chǎn)品</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">第一屆簡歷樣式表設(shè)計(jì)作品下載</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">注冊會(huì)員</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 時(shí)間:2004-11-13 文檔類型:<AC:DOCTYPE /> 來自:<A
href="http://www.blueidea.com/" target=_blank>藍(lán)色理想</A><BR>瀏覽統(tǒng)計(jì)
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可以直接導(dǎo)入SQLserver):<BR>修正一些bug,用多個(gè)目前流行的Access整站和論壇數(shù)據(jù)庫測試(測試最大的80M數(shù)據(jù)庫)<BR>Exe版本可以直接導(dǎo)入到SQL數(shù)據(jù)庫,下載包含Asp
和Exe兩個(gè)版本的文件<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>可以生成完全創(chuàng)建新的SQL庫和登陸,并且導(dǎo)入數(shù)據(jù)的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版本(可以成為一個(gè)小工具),擺脫asp代碼運(yùn)行的不方便!</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下運(yùn)行的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數(shù)據(jù)升遷導(dǎo)入到SQLserver的
Sql腳本<BR>生成結(jié)果需要在SQLserver的查詢分析器里運(yùn)行,使用到dataopensource()函數(shù)):</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的腳本語法細(xì)節(jié)不一樣,所以這兩個(gè)版本是的結(jié)果是完全不同的<BR>第二個(gè)版本可能更實(shí)用</P>
<P align=center><IMG height=477 alt=""
src="Access to Sql 腳本編寫器.files/db_create.png" width=486
border=0></P>
<P><STRONG>出發(fā)點(diǎn)</STRONG></P>
<P>因?yàn)樽鰯?shù)據(jù)庫升級程序,牽涉到建表,建索引,約束,默認(rèn)啊!表關(guān)系的!!!
暈啊!!!!!<BR>全新寫生成數(shù)據(jù)庫結(jié)構(gòu)的Sql語句實(shí)在無比麻煩!</P>
<P>最好的需要是,在Access里弄好表結(jié)構(gòu)設(shè)計(jì),然后像Sql2000那樣對數(shù)據(jù)庫對象編寫Sql腳本,基于這個(gè)處發(fā)點(diǎn),所以編寫了這個(gè)小程序,專門對Access數(shù)據(jù)庫對象編寫Sql腳本,起到事半功倍的作用!
方便方便</P>
<P><STRONG>功能簡介</STRONG> <BR>功能:可編寫Access數(shù)據(jù)庫的常用的主要對象,包括
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -