📄 sql server基本操作-7.htm

📁 微软数据库开发梦工场多媒体教学-sql server篇.rar,是多媒体教学的
💻 HTM
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0071)http://wwwb.pconline.com.cn/pcedu/rookie/program/doc/database/10604.htm -->
<HTML><HEAD><TITLE>PConline-> 网络学院</TITLE><!-- #BeginTemplate "/Templates/rookie-doc.dwt" -->
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<STYLE type=text/css></STYLE>
<LINK href="SQL SERVER基本操作-7.files/text.css" rel=stylesheet>
<SCRIPT language=JavaScript><!--function MM_swapImgRestore() { //v3.0  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;}function MM_preloadImages() { //v3.0  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}}function MM_swapImage() { //v3.0  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}}//--></SCRIPT>

<META content="MSHTML 6.00.2716.2200" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff leftMargin=0 topMargin=0 
onload="MM_preloadImages('/images/lefton.gif','/images/topon.gif')" 
marginheight="0"><A name=top></A>
<SCRIPT language=JavaScript src="SQL SERVER基本操作-7.files/top.js"></SCRIPT>

<TABLE cellSpacing=0 cellPadding=0 width=760 align=center border=0>
  <TBODY>
  <TR>
    <TD width=194 height=56><A href="http://www.pconline.com.cn/"><IMG 
      height=35 src="SQL SERVER基本操作-7.files/pconlinelogo.gif" width=162 
      vspace=10 border=0></A></TD>
    <TD width=406 height=56>
      <SCRIPT language=JavaScript 
      src="SQL SERVER基本操作-7.files/rookie_ad.js"></SCRIPT>
    </TD>
    <TD align=right width=158 height=56>
      <SCRIPT language=JavaScript 
      src="SQL SERVER基本操作-7.files/rookie_ad1.js"></SCRIPT>
    </TD>
    <TD align=right width=2 height=56>&nbsp;</TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=760 align=center border=0>
  <TBODY>
  <TR vAlign=bottom>
    <TD width=172 rowSpan=2><IMG height=32 
      src="SQL SERVER基本操作-7.files/pcedu_lo.gif" width=172 border=0></TD>
    <TD height=30 rowSpan=2>
      <TABLE cellSpacing=0 cellPadding=0 width=588 bgColor=#ffa000 
      background="SQL SERVER基本操作-7.files/e_menu2.gif" border=0>
        <TBODY>
        <TR vAlign=bottom>
          <TD height=17>
            <SCRIPT language=JavaScript 
            src="SQL SERVER基本操作-7.files/title_rookie.js"></SCRIPT>
          </TD></TR></TBODY></TABLE></TD></TR>
  <TR></TR>
  <TR bgColor=#303880>
    <TD vAlign=bottom colSpan=2 height=1><IMG height=1 
      src="SQL SERVER基本操作-7.files/blank.gif" width=1></TD></TR>
  <TR>
    <TD vAlign=bottom colSpan=2 height=5><IMG height=5 
      src="SQL SERVER基本操作-7.files/blank.gif" width=1></TD></TR></TBODY></TABLE>
<TABLE height=614 cellSpacing=0 cellPadding=0 width=760 align=center>
  <TBODY>
  <TR>
    <TD vAlign=top width=170 height=616 rowSpan=2>
      <TABLE height="100%" cellSpacing=1 width=170 bgColor=#000000 border=0>
        <TBODY>
        <TR bgColor=#f8f8d2>
          <TD vAlign=top width="100%" height=307>
            <SCRIPT language=JavaScript 
            src="SQL SERVER基本操作-7.files/left_rookie.js"></SCRIPT>
          </TD></TR></TBODY></TABLE></TD>
    <TD width=8 height=308><IMG height=1 
      src="SQL SERVER基本操作-7.files/blank.gif" width=1></TD>
    <TD vAlign=top width=582 height=444>
      <TABLE height=1 cellSpacing=0 cellPadding=0 width=582 
      background="SQL SERVER基本操作-7.files/line5.gif" border=0>
        <TBODY>
        <TR>
          <TD height=1></TD></TR></TBODY></TABLE><!-- #BeginEditable "content" -->
      <TABLE class=article cellSpacing=8 cellPadding=0 width=582 
      background="SQL SERVER基本操作-7.files/bg6.gif" border=0>
        <TBODY>
        <TR>
          <TD vAlign=top>
            <TABLE cellSpacing=8 cellPadding=0 width="100%" 
            background="SQL SERVER基本操作-7.files/point.gif" border=0>
              <TBODY>
              <TR>
                <TD colSpan=3 height=4></TD></TR>
              <TR>
                <TD colSpan=3 height=22>
                  <DIV class=title align=center>网络数据库设计入门(十四)</DIV></TD></TR>
              <TR vAlign=bottom>
                <TD width=90 height=18>
                  <DIV class=gray align=right>&nbsp;&nbsp;&nbsp;&nbsp;</DIV></TD>
                <TD>
                  <DIV class=gray align=center><FONT color=#666666>作者：心如止水 
                  咖啡豆/太平洋网络学院</FONT></DIV></TD>
                <TD width=90>
                  <DIV class=gray align=right><A 
                  href="mailto:tntst@pconline.com.cn">［责编:爆破手］</A></DIV></TD></TR>
              <TR vAlign=bottom>
                <TD colSpan=3 height=0></TD></TR></TBODY></TABLE>
            <P class=article align=center><B>ODBC与ADO对象</B></P>
            <P><SPAN class=article>1.3 <B>ODBC</B>与<B>ADO</B>对象</SPAN></P>
            <P><SPAN class=article>1.3.2 创建和配置ODBC数据源</SPAN></P>
            <P><SPAN class=article>2.配置ODBC数据源 </SPAN></P>
            <P><SPAN class=article>（2）SQL Server数据库系统DSN的配置方法</SPAN></P>
            <P><SPAN 
            class=article>Step1：在图1.17所示的对话框中单击“添加”按钮，在弹出的对话框中的驱动程序中选择SQL 
            Server项。如图1.22所示。</SPAN></P>
            <P><SPAN class=article><IMG height=367 
            src="SQL SERVER基本操作-7.files/image040.jpg" width=463 
            v:shapes="_x0000_s1045"><BR clear=all><B>图1.22&nbsp; 选择配置SQL 
            Server数据库DSN</B></SPAN></P>
            <P><SPAN 
            class=article>Step2：单击“完成”，这时将弹击一个对话框，在对话框的名称文本输入框中输入要配置的DSN文件名如“test_dsn_sql”在服务器文本输入框中输入SQL 
            Server的服务器名或IP地址，如果SQL 
            Server也是本机的话则输入“127.0.0.1”。如图1.23所示。</SPAN></P>
            <P><SPAN class=article><IMG height=239 
            src="SQL SERVER基本操作-7.files/image042.jpg" width=409 
            v:shapes="_x0000_s1046"><BR clear=all><B>图1.23&nbsp; 建立数据源连接到SQL 
            Server (1)</B></SPAN></P>
            <P><SPAN 
            class=article>Step3：单击“下一步”，这时弹出一个如图1.24的对话框，此时我们如果在第二步时选择的是通过IP地址连接服务器，请选择客户端配置选项，调出如图1.25所图示配置对话框。</SPAN></P>
            <P><SPAN class=article><IMG height=240 
            src="SQL SERVER基本操作-7.files/image044.jpg" width=409 
            v:shapes="_x0000_s1047"><BR clear=all><B>图1.24&nbsp; 建立数据源连接到SQL 
            Server （2）</B></SPAN></P>
            <P class=article align=center><A 
            href="http://wwwb.pconline.com.cn/pcedu/rookie/program/doc/database/10602_1.htm">[上一页]</A> 
            <A 
            href="http://wwwb.pconline.com.cn/pcedu/rookie/program/doc/database/10604_1.htm">[下一页]</A></P></TD></TR>
        <TR bgColor=#ff6600>
          <TD height=1></TD></TR>
        <TR>
          <TD>
            <TABLE cellSpacing=0 cellPadding=0 width="100%" 
            background="SQL SERVER基本操作-7.files/point.gif" border=0>
              <TBODY>
              <TR>
                <TD colSpan=2>
                  <P class=basicfont align=center><BR>如果您有什么疑问或看法请到 <A 
                  class=blue 
                  href="http://home.pconline.com.cn/cgi-bin/newbbs/bbs_login.cgi?loginname=guest&amp;loginpasswd=guest" 
                  target=_blank>精彩论坛</A> 发表意见<BR></P>
                  <P class=basicfont align=center><FONT color=#ff0000><B 
                  class=article>未经同意 不得转载</B></FONT><BR></P>
                  <P class=basicfont align=center><SPAN class=basicfont><A 
                  onmouseover="MM_swapImage('image3','','/images/lefton.gif',1)" 
                  onmouseout=MM_swapImgRestore() 
                  href="javascript:history.back(-1)"><IMG height=22 alt=返回 
                  src="SQL SERVER基本操作-7.files/LEFTOFF.gif" width=19 border=0 
                  name=image3></A> <A 
                  onmouseover="MM_swapImage('image2','','/images/topon.gif',1)" 
                  onmouseout=MM_swapImgRestore() 
                  href="http://wwwb.pconline.com.cn/pcedu/rookie/program/doc/database/10604.htm#top"><IMG 
                  height=22 alt=页首 src="SQL SERVER基本操作-7.files/TOPOFF.gif" 
                  width=22 border=0 
            name=image2></A></SPAN></P></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><!-- #EndEditable -->
      <TABLE height=1 cellSpacing=0 cellPadding=0 width=582 
      background="SQL SERVER基本操作-7.files/line5.gif" border=0>
        <TBODY>
        <TR>
          <TD height=1></TD></TR></TBODY></TABLE><IMG height=24 
      src="G:\数据库教程\SQL Server基本操作\SQL SERVER基本操作-7.files\blank(1).gif" 
      width=1><BR>
      <SCRIPT src="SQL SERVER基本操作-7.files/hotfiles.js"></SCRIPT>
    </TD></TR></TBODY></TABLE>
<HR width=760 noShade SIZE=2>

<P align=center>
<SCRIPT language=JavaScript src="SQL SERVER基本操作-7.files/title_edu.js"></SCRIPT>
<BR><BR>版权所有&copy;2000 太平洋电脑网<BR><FONT face="Arial, Helvetica, sans-serif">
<SCRIPT>document.write("<a href=http://best.netease.com/cgi-bin/view/viewbasic.cgi?exp target=_blank><img src=http://best.netease.com/cgi-bin/log.cgi?user=exp&refer="+escape(document.referrer)+"&cur="+escape(document.URL)+" border=0 alt='网易中文排行榜' width=1 height=1></a>");</SCRIPT>
<A href="mailto:webmaster@pconline.com.cn">mailto:webmaster@pconline.com.cn</A>
<SCRIPT language="">document.write("<a href=http://best.netease.com/cgi-bin/view/viewbasic.cgi?pconline1 target=_blank><img src=http://best.netease.com/cgi-bin/log.cgi?user=pconline1&refer="+escape(document.referrer)+"&cur="+escape(document.URL)+" border=0 width=1 height=1 ></a>");</SCRIPT>

<SCRIPT language="">document.write("<a href=http://count.pconline.com.cn/admin/index.php target=_blank><img src=http://count.pconline.com.cn/count.php?user=pcedu&refer="+escape(document.referrer)+" border=0 width=0 height=0 alt='' ></a>");</SCRIPT>
</FONT></P><!-- #EndTemplate --></BODY></HTML>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -