12636.htm

一本很基础的SQL讲解

<link href="./dzs_cs.css" rel="stylesheet" type="text/css" />
<table width="96%" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td height="24" align="center" valign="bottom" class="d_font3">SQL Server 2000简介</td>
      </tr>
      <tr>
        <td height="3" bgcolor="#E3E3E3"></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td class="d_font4"><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US>SQL Server </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">是一个关系数据库管理系统。它最初是由</SPAN><SPAN lang=EN-US>Microsoft Sybase </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">和</SPAN><SPAN lang=EN-US>Ashton-Tate</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">三家公司共同开发的，于</SPAN><SPAN lang=EN-US>1988 </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">年推出了第一个</SPAN><SPAN lang=EN-US>OS/2 </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">版本。在</SPAN><SPAN lang=EN-US>Windows NT </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">推出后，</SPAN><SPAN lang=EN-US>Microsoft</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">与</SPAN><SPAN lang=EN-US>Sybase </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">在</SPAN><SPAN lang=EN-US>SQL Server </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">的开发上就分道扬镳了。</SPAN><SPAN lang=EN-US>Microsoft </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">将</SPAN><SPAN lang=EN-US>SQL Server </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">移植到</SPAN><SPAN lang=EN-US>Windows NT</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">系统上，专注于开发推广</SPAN><SPAN lang=EN-US>SQL Server </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">的</SPAN><SPAN lang=EN-US>Windows NT </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">版本。</SPAN><SPAN lang=EN-US>Sybase </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">则较专注于</SPAN><SPAN lang=EN-US>SQL Server</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">在</SPAN><SPAN lang=EN-US>UNIX </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">操作系统上的应用。</SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US></SPAN>&nbsp;</P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US>SQL Server 2000， </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">是</SPAN><SPAN lang=EN-US>Microsoft </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">公司推出的</SPAN><SPAN lang=EN-US>SQL Server </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">数据库管理系统的新版本。该版本继承了</SPAN><SPAN lang=EN-US>SQL Server 7.0 </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">版本的优点，同时又比它增加了许多更先进的功能，具有使用方便、可伸缩性好、与相关软件集成程度高等优点。可跨越从运行</SPAN><SPAN lang=EN-US>Microsoft Windows 98 </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">的膝上型电脑，到运行</SPAN><SPAN lang=EN-US>Microsoft Windows 2000 </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">的大型多处理器的服务器等多种平台使用。</SPAN></P><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">
<P><SPAN class=style2><STRONG>SQL Server 2000 的常见版本</STRONG></SPAN></P>
<P>·企业版（Enterprise Edition）<BR>支持所有的SQL Server 2000 特性，可作为大型Web站点、企业OLTP（联机事务处理）以及数据仓库系统等的产品数据库服务器。<BR>·标准版（Standard Edition）<BR>用于小型的工作组或部门<BR>·个人版（Personal Edition）<BR>用于单机系统或客户机<BR>·开发者版（Developer Edition）<BR>用于程序员开发应用程序，这些程序需要SQL Server 2000 作为数据存储设备。</P>
<P>此外，SQL Server 2000 还有桌面引擎（Desktop Engine） 和Windows CE 版。用户可以根据实际情况选择所要安装的SQL Server 2000 版本。<BR><BR><STRONG>运行SQL Server 2000 的最低硬件和软件需求</STRONG><BR><BR><SPAN class=style2>1 硬件需求</SPAN></P>
<P>&nbsp;&nbsp;1、计算机<BR>&nbsp;&nbsp;&nbsp;&nbsp;Intel 兼容计算机，Pentium 166 MHz 以上。<BR>&nbsp;&nbsp;2、内存RAM<BR>&nbsp;&nbsp;&nbsp;&nbsp;Enterprise：版本64 MB。<BR>&nbsp;&nbsp;&nbsp;&nbsp;Standard：版本32 MB。<BR>&nbsp;&nbsp;3、硬盘空间<BR>SQL Server 2000：<BR>&nbsp;·完全安装（Full） 180 MB<BR>&nbsp;·典型安装（Typical） 170 MB<BR>&nbsp;·最小安装（minimum 65） MB<BR>&nbsp;·只安装管理工具（Client tools only） 90 MB<BR>&nbsp;&nbsp;&nbsp;&nbsp;Analysis Services：50 MB<BR>&nbsp;&nbsp;&nbsp;&nbsp;English Query：12 MB<BR><BR><SPAN class=style2>2 软件需求</SPAN><BR><BR>1、操作系统</P>
<P>各常用的操作系统与可安装的SQL Server 2000 的版本关系如表2-1 所示其中“Y”表示可安装的对应版本，“N”表示不能安装的对应版本。<BR><BR><STRONG>注意：</STRONG>上表中的 Windows NT Server 4.0 系列操作系统需要安装 Service Pack 5(SP 5)或更高级的压缩包软件</P>
<P>2、网络软件</P>
<P>如果使用的操作系统是Microsoft Windows NT、Windows 2000、Windows 98 或Windows95，则无需再额外安装网络软件。且SQL Server 2000 支持Windows NT Workstation、Windows 2000 Professional、Windows 98、Windows 95、Apple Macintosh、OS/2 以及UNIX客户端连接。</SPAN></P></td>
      </tr>
      <tr>
        <td class="d_font4">&nbsp;</td>
      </tr>
    </table>