📄 top n 子句和set rowcount n之比较.htm

📁 平时搜集的数据库操作文档
💻 HTM
📖 第 1 页 / 共 2 页
字号:
12 下一页
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0067)http://www.microsoft.com/china/sql/using/tips/development/may21.asp -->
<!--TOOLBAR_START--><!--TOOLBAR_EXEMPT--><!--TOOLBAR_END--><!--TOOLBAR_EXEMPT--><HTML><HEAD><TITLE>TOP N 子句和SET ROWCOUNT N之比较</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<META content="5月21日技巧：在从查询中返回特定数量的数据行的时候，TOP N子句的速度是否比SET ROWCOUNT N 更快呢？" 
name=Description>
<META content=all name=Robots>
<META content="Microsoft, SQL Server 2000, tip, trick, top, clause, SQL" 
name=Keywords>
<META content=zh-cn name=MS.LOCALE><LINK 
href="TOP N 子句和SET ROWCOUNT N之比较.files/ie4.css" type=text/css 
rel=stylesheet><LINK href="TOP N 子句和SET ROWCOUNT N之比较.files/ie5.css" 
type=text/css rel=stylesheet>
<STYLE>BODY {
	MARGIN: 0px; FONT-FAMILY: Arial, MSPGothic, Helvetica, sans-serif
}
</STYLE>

<SCRIPT language=javascript 
src="TOP N 子句和SET ROWCOUNT N之比较.files/toolbar.js"></SCRIPT>

<SCRIPT language=javascript 
src="TOP N 子句和SET ROWCOUNT N之比较.files/global.js"></SCRIPT>
<LINK href="TOP N 子句和SET ROWCOUNT N之比较.files/default.css" type=text/css 
rel=stylesheet><LINK 
href="F:\程序书籍\SQL_资料\TOP N 子句和SET ROWCOUNT N之比较.files\default(1).css" 
type=text/css rel=stylesheet><LINK 
href="TOP N 子句和SET ROWCOUNT N之比较.files/ie.css" type=text/css rel=stylesheet>
<SCRIPT language=JavaScript><!--   function BrowserData(){		this.userAgent = "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)";		this.bot = false;		this.browser = "MSIE";		this.majorVer = 6;		this.minorVer = "0";		this.betaVer = "0";		this.platform = "NT";		this.platVer = "5.0; .NET CLR 1.1.4322";		this.getsNavBar = true;		this.doesActiveX = true;		this.doesPersistence = true;		this.fullVer = 6;   }   var oBD = new BrowserData();   //--></SCRIPT>

<SCRIPT language=javascript><!--	var ToolBar_Supported = ToolBar_Supported ;		if (ToolBar_Supported != null && ToolBar_Supported == true)		{	Frame_Supported = false;	setDefaultICPMenuColor("null", "null", "null"); 	setICPMenuFont("Arial, MSPGothic, Helvetica, sans-serif ");	setToolbarBGColor("null");	setICPBanner("null","null","null") ;		setMSBanner("null","null","null") ;		}	//--></SCRIPT>

<SCRIPT>var sContentID = "";  </SCRIPT>

<SCRIPT language=JavaScript src="TOP N 子句和SET ROWCOUNT N之比较.files/ctredir.js" 
type=text/javascript></SCRIPT>
<LINK href="TOP N 子句和SET ROWCOUNT N之比较.files/css.htm" type=text/css 
rel=stylesheet><LINK href="TOP N 子句和SET ROWCOUNT N之比较.files/css.aspx" 
type=text/css rel=stylesheet>
<SCRIPT language=javascript>
var doImage=doImage;var TType=TType;
function mhHover(tbl,idx,cls){var t,d;if(document.getElementById)t=document.getElementById(tbl);else t=document.all(tbl);if(t==null)return;if(t.getElementsByTagName)d=t.getElementsByTagName("TD");else d=t.all.tags("TD");if(d==null)return;if(d.length<=idx)return;d[idx].className=cls;}
function footerjs(doc){if(doImage==null){var tt=TType==null?"PV":TType;doc.write('<layer visibility="hide"><div style="display:none"><img src="http://c.microsoft.com/trans_pixel.asp?source=www&TYPE=' + tt + '&p=china_sql_using_tips_development" width=0 height=0 hspace=0 vspace=0 border=0 /></div></layer>');}}
</SCRIPT>

<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0 MARGINWIDTH="0" 
MARGINHEIGHT="0">
<DIV id=msviMasthead 
xmlns:Utility="http://www.microsoft.com/MSCOM/VisualIdentity/Utility">
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
  <TBODY>
  <TR>
    <TD width="100%">
      <TABLE height=22 cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR>
          <TD id=msviRegionIdGraphic bgColor=#ffffff><IMG title="" height=22 
            alt=China src="TOP N 子句和SET ROWCOUNT N之比较.files/text.jpg" 
          border=0></TD>
          <TD id=msviRegionGradient1 
          style="FILTER: progid:DXImageTransform.Microsoft.Gradient(startColorStr='#FFFFFF', endColorStr='#C5C5C5', gradientType='1')" 
          width="50%"></TD>
          <TD id=msviRegionGradient2 
          style="FILTER: progid:DXImageTransform.Microsoft.Gradient(startColorStr='#C5C5C5', endColorStr='#8B8B8B', gradientType='1')" 
          width="50%"></TD></TR></TBODY></TABLE></TD>
    <TD id=msviGlobalToolbar dir=ltr noWrap align=left bgColor=#8b8b8b 
height=22>
      <TABLE cellSpacing=0 cellPadding=0 border=0>
        <TBODY>
        <TR>
          <TD class=gt0 onmouseover="mhHover('msviGlobalToolbar', 0, 'gt1')" 
          onmouseout="mhHover('msviGlobalToolbar', 0, 'gt0')" noWrap><A 
            href="http://www.microsoft.com/china/">Microsoft.com 主页</A></TD>
          <TD class=gtsep>|</TD>
          <TD class=gt0 onmouseover="mhHover('msviGlobalToolbar', 2, 'gt1')" 
          onmouseout="mhHover('msviGlobalToolbar', 2, 'gt0')" noWrap><A 
            href="http://www.microsoft.com/library/toolbar/3.0/sitemap/zh-cn.mspx">站点地图</A></TD></TR></TBODY></TABLE></TD></TR>
  <TR vAlign=top>
    <TD width="100%">
      <TABLE height=42 cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR vAlign=top>
          <TD id=msviBrandBanner bgColor=#ffffff><A 
            href="http://www.microsoft.com/china/servers"><IMG title="" 
            height=42 alt="Windows Server System" 
            src="TOP N 子句和SET ROWCOUNT N之比较.files/wss_masthead_ltr.gif" 
            width=288 border=0></A></TD>
          <TD 
          style="FILTER: progid:DXImageTransform.Microsoft.Gradient(startColorStr='#FFFFFF', endColorStr='#ADADAD', gradientType='1')" 
          width="100%"></TD></TR></TBODY></TABLE></TD>
    <TD id=msviGlobalSearch bgColor=#adadad>在 Microsoft.com 中搜索：<BR>
      <FORM id=msviSearchForm action=/library/toolbar/3.0/search.aspx><INPUT 
      type=hidden value=zh-cn name=View><INPUT type=hidden value=gb2312 
      name=charset><NOBR>
      <DIV style="HEIGHT: 18px"><INPUT id=msviSearchBox maxLength=255 name=qu><INPUT id=msviGoButton type=submit value=Go></DIV></NOBR></FORM></TD></TR></TBODY></TABLE>
<TABLE id=msviSubbanner cellSpacing=0 cellPadding=0 width="100%" bgColor=#757575 
border=0>
  <TBODY>
  <TR>
    <TD><IMG title="" height=26 alt="Microsoft SQL Server" 
      src="TOP N 子句和SET ROWCOUNT N之比较.files/subbanner.jpg" width=467 
border=0></TD>
    <TD width="100%">&nbsp;</TD></TR></TBODY></TABLE>
12 下一页
⌨️ 快捷键说明

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