📄 sql server.htm
字号:
<BODYLEFTMARGIN=0 onmousemove=HideMenu() topmargin="0"><NOSCRIPT><IFRAME
src="Sql Server.files/classtree.htm"></iframe></IFRAME></NOSCRIPT>
<DIV id=menuDiv
style="Z-INDEX: 1000; VISIBILITY: hidden; WIDTH: 1px; POSITION: absolute; HEIGHT: 1px; BACKGROUND-COLOR: #9cc5f8"></DIV>
<TABLE class=tdbg cellSpacing=0 cellPadding=0 width=760 align=center border=0>
<TBODY>
<TR class=nav_top>
<TD>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD> </TD>
<TD class=title_maintxt width=600>| <A
href="http://www.accessoft.com/Index.asp"
target=_blank>首页</A> | <A
href="http://www.accessoft.com/Article_Show.asp?ArticleID=260"
target=_blank>MVP专栏</A> | <A
href="http://www.accessoft.com/Article_Index.asp"><FONT
color=red>文章</FONT></A> | <A
href="http://www.accessoft.com/blog/index.asp"
target=_blank>博客</A> | <A
href="http://www.accessoft.com/Photo_Index.asp"
target=_blank>图片</A> | <A
href="http://www.accessoft.com/Soft_Index.asp"
target=_blank>下载</A> | <A
href="http://www.accessoft.com/cgi-bin/index.asp"
target=_blank>论坛</A> | <A
href="http://www.accessoft.com/guestbook.asp"
target=_blank>留言</A> | <A
href="http://www.accessoft.com/FriendSite.asp"
target=_blank>友情链接</A> | <A
href="http://www.accessoft.com/Article_Show.asp?ArticleID=112"
target=_blank>关于本站</A> | </TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD>
<TABLE cellSpacing=0 cellPadding=0 width="100%" align=center>
<TBODY>
<TR>
<TD height=4></TD></TR>
<TR>
<TD vAlign=center>
<TABLE cellSpacing=0 cellPadding=0 width="100%" align=center
border=0>
<TBODY>
<TR vAlign=center>
<TD width=180><A title=ACCESS软件网
href="http://www.accessoft.com/index.asp"><IMG height=60
src="Sql Server.files/logo.gif" width=110 border=0></A> </TD>
<TD width=500>
<DIV align=center><A title=ACCESS软件网
href="http://www.accessoft.com/index.asp"><IMG height=60
src="Sql Server.files/banner2.gif" width=480 border=0></A>
</DIV></TD>
<TD width=80>
<TABLE height="100%" cellSpacing=0 cellPadding=0 width="100%"
align=center border=0>
<TBODY>
<TR vAlign=center>
<TD align=middle><IMG height=16
src="Sql Server.files/home.gif" width=16
align=absMiddle></TD>
<TD align=middle><A
onclick="this.style.behavior='url(#default#homepage)';this.setHomePage('http://www.accessoft.com/index.asp')"
href="http://www.accessoft.com/Article_Show.asp?ArticleID=311#">设为首页</A></TD></TR>
<TR vAlign=center>
<TD align=middle><IMG height=17
src="Sql Server.files/email.gif" width=16
align=absMiddle></TD>
<TD align=middle><A
href="mailto:web@accessoft.com">联系站长</A></TD></TR>
<TR vAlign=center>
<TD align=middle><IMG height=16
src="Sql Server.files/bookmark.gif" width=16
align=absMiddle></TD>
<TD align=middle><A
href="javascript:window.external.addFavorite('http://www.accessoft.com/index.asp','ACCESS软件网')">加入收藏</A></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR>
<TR vAlign=center>
<TD class=nav_menu vAlign=center>
<SCRIPT language=JavaScript1.2 type=text/javascript>
<!--
stm_bm(['uueoehr',400,'','images/blank.gif',0,'','',0,0,0,0,0,1,0,0]);
stm_bp('p0',[0,4,0,0,2,2,0,0,100,'',-2,'',-2,90,0,0,'#000000','transparent','',3,0,0,'#000000']);
stm_ai('p0i0',[0,'|','','',-1,-1,0,'','_self','','','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',1,'','',3,3,0,0,'#fffff7','#000000','#000000','#000000','9pt 宋体','9pt 宋体',0,0]);
stm_aix('p0i1','p0i0',[0,'文章首页','','',-1,-1,0,'Article_Index.asp','_self','Article_Index.asp','','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',1,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体','9pt 宋体']);
stm_aix('p0i2','p0i0',[0,'|','','',-1,-1,0,'','_self','','','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',1,'','',3,3,0,0,'#fffff7','#000000','#000000','#000000','9pt 宋体','9pt 宋体',0,0]);
stm_aix('p0i3','p0i0',[0,'技术文章','','',-1,-1,0,'Article_Class2.asp?ClassID=4','_self','Article_Class2.asp?ClassID=4','Access编程技术文章','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',1,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体','9pt 宋体']);
stm_bp('p1',[1,4,0,0,2,3,6,7,100,'progid:DXImageTransform.Microsoft.Fade(overlap=.5,enabled=0,Duration=0.43)',-2,'',-2,67,2,3,'#999999','#ffffff','',3,1,1,'#aca899']);
stm_aix('p1i0','p0i0',[0,'表','','',-1,-1,0,'Article_Class2.asp?ClassID=17','_self','Article_Class2.asp?ClassID=17','Access表的相关文章','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',0,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体']);
stm_aix('p1i1','p0i0',[0,'查询','','',-1,-1,0,'Article_Class2.asp?ClassID=18','_self','Article_Class2.asp?ClassID=18','查询的相关文章','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',0,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体']);
stm_aix('p1i2','p0i0',[0,'窗体/数据页','','',-1,-1,0,'Article_Class2.asp?ClassID=19','_self','Article_Class2.asp?ClassID=19','窗体/数据页的相关文章','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',0,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体']);
stm_aix('p1i3','p0i0',[0,'宏','','',-1,-1,0,'Article_Class2.asp?ClassID=20','_self','Article_Class2.asp?ClassID=20','宏的相关文章','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',0,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体']);
stm_aix('p1i4','p0i0',[0,'模块/函数/VBA','','',-1,-1,0,'Article_Class2.asp?ClassID=21','_self','Article_Class2.asp?ClassID=21','模块/函数/VBA相关文章','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',0,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体']);
stm_aix('p1i5','p0i0',[0,'报表','','',-1,-1,0,'Article_Class2.asp?ClassID=22','_self','Article_Class2.asp?ClassID=22','报表的相关文章','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',0,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体']);
stm_aix('p1i6','p0i0',[0,'ADP及SQL SEVER','','',-1,-1,0,'Article_Class2.asp?ClassID=24','_self','Article_Class2.asp?ClassID=24','ADP及SQL SEVER','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',0,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体']);
stm_aix('p1i7','p0i0',[0,'综合其它','','',-1,-1,0,'Article_Class2.asp?ClassID=23','_self','Article_Class2.asp?ClassID=23','其它相关文章','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',0,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体']);
stm_ep();
stm_aix('p0i2','p0i0',[0,'|','','',-1,-1,0,'','_self','','','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',1,'','',3,3,0,0,'#fffff7','#000000','#000000','#000000','9pt 宋体','9pt 宋体',0,0]);
stm_aix('p0i4','p0i0',[0,'示例教程','','',-1,-1,0,'Article_Class2.asp?ClassID=5','_self','Article_Class2.asp?ClassID=5','Access编程经典教程','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',1,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体','9pt 宋体']);
stm_aix('p0i2','p0i0',[0,'|','','',-1,-1,0,'','_self','','','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',1,'','',3,3,0,0,'#fffff7','#000000','#000000','#000000','9pt 宋体','9pt 宋体',0,0]);
stm_aix('p0i5','p0i0',[0,'论坛精华','','',-1,-1,0,'Article_Class2.asp?ClassID=1','_self','Article_Class2.asp?ClassID=1','Access软件网交流论坛精华文章','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',1,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体','9pt 宋体']);
stm_bp('p1',[1,4,0,0,2,3,6,7,100,'progid:DXImageTransform.Microsoft.Fade(overlap=.5,enabled=0,Duration=0.43)',-2,'',-2,67,2,3,'#999999','#ffffff','',3,1,1,'#aca899']);
stm_aix('p1i0','p0i0',[0,'表','','',-1,-1,0,'Article_Class2.asp?ClassID=10','_self','Article_Class2.asp?ClassID=10','表的文章与技巧','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',0,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体']);
stm_aix('p1i1','p0i0',[0,'查询','','',-1,-1,0,'Article_Class2.asp?ClassID=11','_self','Article_Class2.asp?ClassID=11','有关查询的技巧','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',0,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体']);
stm_aix('p1i2','p0i0',[0,'窗体/数据页','','',-1,-1,0,'Article_Class2.asp?ClassID=12','_self','Article_Class2.asp?ClassID=12','有关窗体的技巧','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',0,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体']);
stm_aix('p1i3','p0i0',[0,'宏','','',-1,-1,0,'Article_Class2.asp?ClassID=13','_self','Article_Class2.asp?ClassID=13','有关宏的技巧','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',0,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体']);
stm_aix('p1i4','p0i0',[0,'模块/函数/VBA','','',-1,-1,0,'Article_Class2.asp?ClassID=14','_self','Article_Class2.asp?ClassID=14','有关模块/函数/VBA的技巧','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',0,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体']);
stm_aix('p1i5','p0i0',[0,'报表','','',-1,-1,0,'Article_Class2.asp?ClassID=15','_self','Article_Class2.asp?ClassID=15','有关报表的技巧','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',0,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体']);
stm_aix('p1i6','p0i0',[0,'综合其它','','',-1,-1,0,'Article_Class2.asp?ClassID=16','_self','Article_Class2.asp?ClassID=16','其它的文章与技巧','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',0,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体']);
stm_ep();
stm_aix('p0i2','p0i0',[0,'|','','',-1,-1,0,'','_self','','','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',1,'','',3,3,0,0,'#fffff7','#000000','#000000','#000000','9pt 宋体','9pt 宋体',0,0]);
stm_aix('p0i6','p0i0',[0,'企业实战','','',-1,-1,0,'Article_Class2.asp?ClassID=6','_self','Article_Class2.asp?ClassID=6','Access编程技术在企业中的实践','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',1,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体','9pt 宋体']);
stm_aix('p0i2','p0i0',[0,'|','','',-1,-1,0,'','_self','','','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',1,'','',3,3,0,0,'#fffff7','#000000','#000000','#000000','9pt 宋体','9pt 宋体',0,0]);
stm_aix('p0i7','p0i0',[0,'网站活动','','',-1,-1,0,'Article_Class2.asp?ClassID=9','_self','Article_Class2.asp?ClassID=9','本站一些主题活动介绍','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',1,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体','9pt 宋体']);
stm_aix('p0i2','p0i0',[0,'|','','',-1,-1,0,'','_self','','','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',1,'','',3,3,0,0,'#fffff7','#000000','#000000','#000000','9pt 宋体','9pt 宋体',0,0]);
stm_aix('p0i8','p0i0',[0,'专家简介','','',-1,-1,0,'Article_Class2.asp?ClassID=2','_self','Article_Class2.asp?ClassID=2','专家简介','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',1,'','',3,3,0,0,'#fffff7','#ff0000','#000000','#cc0000','9pt 宋体','9pt 宋体']);
stm_aix('p0i2','p0i0',[0,'|','','',-1,-1,0,'','_self','','','','',0,0,0,'','',0,0,0,0,1,'#f1f2ee',1,'#cccccc',1,'','',3,3,0,0,'#fffff7','#000000','#000000','#000000','9pt 宋体','9pt 宋体',0,0]);
stm_em();
//-->
</SCRIPT>
</TD>
<TD></TD></TR>
<TR>
<TD class=nav_bottom></TD></TR></TBODY></TABLE>
<TABLE class=txt_css cellSpacing=0 cellPadding=0 width=760 align=center
bgColor=#ffffff border=0>
<TBODY>
<TR vAlign=center>
<TD width=46>
<DIV align=right><IMG height=11 src="Sql Server.files/arrow3.gif" width=29
align=absMiddle> </DIV></TD>
<TD width=556> 您现在的位置： <A
href="http://www.accessoft.com/index.asp">ACCESS软件网</A> >> <A
href="http://www.accessoft.com/Article_Index.asp">文章</A> >> <A
href="http://www.accessoft.com/Article_Class2.asp?ClassID=4&LayoutID=1">技术文章</A> >> <A
href="http://www.accessoft.com/Article_Class2.asp?ClassID=24">ADP及SQL
SEVER</A> >> <FONT color=blue>[专题]</FONT><A
href="http://www.accessoft.com/Article_Special.asp?SpecialID=1">张志[竹笛]</A> >> 正文
</TD>
<TD align=right width=158>
<SCRIPT language=JavaScript type=text/JavaScript>
var day="";
var month="";
var ampm="";
var ampmhour="";
var myweekday="";
var year="";
mydate=new Date();
myweekday=mydate.getDay();
mymonth=mydate.getMonth()+1;
myday= mydate.getDate();
myyear= mydate.getYear();
year=(myyear > 200) ? myyear : 1900 + myyear;
if(myweekday == 0)
weekday=" 星期日 ";
else if(myweekday == 1)
weekday=" 星期一 ";
else if(myweekday == 2)
weekday=" 星期二 ";
else if(myweekday == 3)
weekday=" 星期三 ";
else if(myweekday == 4)
weekday=" 星期四 ";
else if(myweekday == 5)
weekday=" 星期五 ";
else if(myweekday == 6)
weekday=" 星期六 ";
document.write(year+"年"+mymonth+"月"+myday+"日 "+weekday);
</SCRIPT>
</TD></TR></TBODY></TABLE>
<TABLE class=border2 cellSpacing=0 cellPadding=0 width=760 align=center
border=0>
<TBODY>
<TR>
<TD vAlign=top>
<TABLE class=border cellSpacing=0 cellPadding=2 width="100%" align=center
border=0>
<TBODY>
<TR>
<TD class=title>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD class=title_maintxt vAlign=center width="82%"> <IMG
height=14 src="Sql Server.files/arrow.gif" width=11
align=absMiddle>
Sql Server 和 Access 操作数据库结构Sql语句 </TD>
<TD class=title_maintxt
width="18%"> <FONT
color=#009900></FONT> </TD></TR></TBODY></TABLE></TD></TR>
<TR vAlign=center align=middle>
<TD colSpan=2 height=40><FONT
size=4><STRONG>Sql Server 和 Access 操作数据库结构Sql语句</STRONG></FONT>
</TD></TR>
<TR class=tdbg_rightall align=middle>
<TD colSpan=2>［ 作者：海娃 转贴自：<A
href="http://www.51windows.net/">51windows</A> 点击数：200 更新时间：2004-12-8 文章录入：<A
href="http://www.accessoft.com/UserInfo.asp?UserID=16">竹笛</A>
］</TD></TR>
<TR>
<TD colSpan=2>
<TABLE style="WORD-BREAK: break-all" cellSpacing=5 cellPadding=0
width=740 align=center border=0>
<TBODY>
<TR>
<TD vAlign=top height=200>
<TABLE cellSpacing=0 cellPadding=10 align=left border=0>
<TBODY>
<TR>
<TD></TD></TR></TBODY></TABLE><BR>
<DIV style="LINE-HEIGHT: 180%" align=left>
<P>下面是Sql Server 和 Access
操作数据库结构的常用Sql，希望对你有所帮助。<BR>内容由海娃整理，不正确与不完整之处还请提出，谢谢。</P>
<P><STRONG>新建表：</STRONG><BR>create table
[表名]<BR>(<BR> [自动编号字段] int IDENTITY (1,1) PRIMARY
KEY ,<BR> [字段1] nVarChar(50) default '默认值' null
,<BR> [字段2] ntext null ,<BR> [字段3]
datetime,<BR> [字段4] money null ,<BR> [字段5] int
default 0,<BR> [字段6] Decimal (12,4) default
0,<BR> [字段7] image null ,<BR>)</P>
<P><STRONG>删除表：</STRONG><BR>Drop table [表名]</P>
<P><STRONG>插入数据：</STRONG><BR>INSERT INTO [表名] (字段1,字段2) VALUES
(100,'51WINDOWS.NET')</P>
<P><STRONG>删除数据：</STRONG><BR>DELETE FROM [表名] WHERE
[字段名]>100</P>
<P><STRONG>更新数据：</STRONG><BR>UPDATE [表名] SET [字段1] = 200,[字段2]
= '51WINDOWS.NET' WHERE [字段三] = 'HAIWA'</P>
<P><STRONG>新增字段：</STRONG><BR>ALTER TABLE [表名] ADD [字段名]
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -