📄 sql server2005 的快速分页 row_number() over (order by reportid).mht
字号:
=0A=
=0A=
//-->=0A=
</SCRIPT>
<META content=3D"MSHTML 6.00.2900.3429" name=3DGENERATOR></HEAD>
<BODY onload=3Dformatonlinpic();>
<CENTER>
<SCRIPT type=3Dtext/javascript>=0A=
/*<![CDATA[*/=0A=
if(top.location !=3D self.location){=0A=
top.location =3D self.location;=0A=
}=0A=
var myref =3D =
encodeURIComponent("http://hi.baidu.com/meilixueshan/blog/item/66e0b1ec04=
4a742462d09ff8%2Ehtml");=0A=
/*]]>*/=0A=
</SCRIPT>
<LINK href=3D"http://hi.baidu.com/ui/css/mods.css" type=3Dtext/css=20
rel=3Dstylesheet><LINK=20
href=3D"http://hi.baidu.com/meilixueshan/css/item/cf3163ec8a862bd12f2e21c=
5.css"=20
type=3Dtext/css rel=3Dstylesheet><LINK =
href=3D"http://hi.baidu.com/space.css"=20
type=3Dtext/css rel=3Dstylesheet>
<STYLE type=3Dtext/css>#usrbar {
PADDING-RIGHT: 10px; PADDING-LEFT: 0px; FONT-SIZE: 12px; BACKGROUND: =
#ffffff; FILTER: alpha(opacity=3D65); PADDING-BOTTOM: 3px; WIDTH: 100%; =
COLOR: #000000; LINE-HEIGHT: 19px; PADDING-TOP: 4px; FONT-FAMILY: Arial; =
LETTER-SPACING: normal; HEIGHT: 19px; TEXT-ALIGN: right; moz-opacity: =
0.5
}
#usrbar A {
COLOR: #0000cc; TEXT-DECORATION: underline
}
#usrbar A:link {
COLOR: #0000cc; TEXT-DECORATION: underline
}
#usrbar A:visited {
COLOR: #0000cc; TEXT-DECORATION: underline
}
#ft {
CLEAR: both; FONT-SIZE: 12px; COLOR: #666666; LINE-HEIGHT: 20px; =
FONT-FAMILY: Arial; HEIGHT: 20px; TEXT-ALIGN: center
}
#ft A {
COLOR: #7777cc; TEXT-DECORATION: underline
}
#ft A:link {
COLOR: #7777cc; TEXT-DECORATION: underline
}
#ft A:visited {
COLOR: #7777cc; TEXT-DECORATION: underline
}
#usrbar {
LETTER-SPACING: normal
}
#usrbar A {
LETTER-SPACING: normal
}
#usrbar A:link {
LETTER-SPACING: normal
}
#usrbar A:visited {
LETTER-SPACING: normal
}
#ft {
LETTER-SPACING: normal
}
#ft A {
LETTER-SPACING: normal
}
#ft A:link {
LETTER-SPACING: normal
}
#ft A:visited {
LETTER-SPACING: normal
}
</STYLE>
<DIV id=3Dusrbar><NOBR><A href=3D"http://www.baidu.com/" =
target=3D_blank>=B0=D9=B6=C8=CA=D7=D2=B3</A> | <A=20
id=3Dhi_index href=3D"http://hi.baidu.com/" =
target=3D_blank>=B0=D9=B6=C8=BF=D5=BC=E4</A>
<SCRIPT type=3Dtext/javascript>=0A=
document.write('| <a =
href=3D"http://passport.baidu.com/?login&tpl=3Dsp&tpl_reg=3Dsp&u=3Dhttp:/=
/hi.baidu.com' + =
encodeURIComponent('/meilixueshan/blog/item/66e0b1ec044a742462d09ff8%2Eht=
ml') + '">=B5=C7=C2=BC</a>');=0A=
</SCRIPT>
</NOBR></DIV>
<DIV id=3Dmain align=3Dleft><!--[if IE]>
<SCRIPT>
var objmain =3D document.getElementById("main");
function updatesize(){ var bodyw =3D window.document.body.offsetWidth; =
if(bodyw <=3D 790) objmain.style.width=3D"772px"; else if(bodyw >=3D =
1016) objmain.style.width=3D"996px"; else objmain.style.width=3D"100%"; =
}
updatesize(); window.onresize =3D updatesize;
</SCRIPT>
<![endif]-->
<DIV id=3Dheader>
<DIV class=3Dlc>
<DIV class=3Drc></DIV></DIV>
<DIV class=3Dtit><A class=3Dtitlink=20
title=3D"meilixueshan=B5=C4=BF=D5=BC=E4 =
http://hi.baidu.com/meilixueshan"=20
href=3D"http://hi.baidu.com/meilixueshan">=C3=B7=C0=EF=D1=A9=C9=BD[=C8=CB=
=C9=FA=BC=B4=CA=C7=B5=C8=B4=FD=CB=C0=CD=F6=B5=C4=B9=FD=B3=CC]</A></DIV>
<DIV=20
class=3Ddesc>=D0=E9=CE=DE=CE=DE=CB=F9=B2=BB=D4=DA=A3=AC=CE=DE=CB=F9=B2=BB=
=C8=DD=A3=BB=D0=E9=CE=DE=B0=FC=C0=A8=D2=BB=C7=D0=A3=AC=C3=BB=D3=D0=CF=E0=B7=
=B4=A3=AC=C3=BB=D3=D0=B6=D4=C1=A2=A3=AC=D2=B2=C3=BB=D3=D0=C5=C5=B3=E2=A3=AC=
=D2=F2=CE=AA=CB=FC=CA=C7=CD=F2=CE=EF=D6=AE=D4=B4=A3=AC=C8=CF=CA=B6=D0=E9=CE=
=DE=B5=C4=C8=CB=B6=BC=B3=E4=C2=FA=C9=FA=C3=FC=C1=A6=BA=CD=B0=AE=D0=C4=A3=A1=
</DIV>
<DIV id=3Dtabline></DIV>
<DIV id=3Dtab><A =
href=3D"http://hi.baidu.com/meilixueshan">=D6=F7=D2=B3</A><A class=3Don=20
href=3D"http://hi.baidu.com/meilixueshan/blog">=B2=A9=BF=CD</A><A=20
href=3D"http://hi.baidu.com/meilixueshan/album">=CF=E0=B2=E1</A><SPAN>|</=
SPAN><A=20
href=3D"http://hi.baidu.com/meilixueshan/profile">=B8=F6=C8=CB=B5=B5=B0=B8=
</A> <SPAN>|</SPAN><A=20
href=3D"http://hi.baidu.com/meilixueshan/friend">=BA=C3=D3=D1</A> =
</DIV></DIV>
<DIV class=3Dstage>
<DIV class=3Dstagepad>
<DIV style=3D"WIDTH: 100%">
<TABLE class=3Dmodth cellSpacing=3D0 cellPadding=3D0 width=3D"100%" =
border=3D0>
<TBODY>
<TR>
<TD class=3Dmodtl width=3D7> </TD>
<TD class=3Dmodtc noWrap>
<DIV class=3Dmodhead><SPAN =
class=3Dmodtit>=B2=E9=BF=B4=CE=C4=D5=C2</SPAN></DIV></TD>
<TD class=3Dmodtc noWrap align=3Dright></TD>
<TD class=3Dmodtr width=3D7> </TD></TR></TBODY></TABLE>
<DIV class=3Dmodbox id=3Dm_blog>
<DIV class=3Dtit>Sql Server2005 =B5=C4=BF=EC=CB=D9=B7=D6=D2=B3 =
ROW_NUMBER() OVER (ORDER BY ReportID)</DIV>
<DIV class=3Ddate>2007-09-14 11:05</DIV>
<TABLE style=3D"TABLE-LAYOUT: fixed">
<TBODY>
<TR>
<TD>
<DIV class=3Dcnt id=3Dblog_text> =
=C7=B0=C3=E6=D2=BB=C6=AA=CB=E6=B1=CA,=CE=D2=CC=E1=B5=BD=C1=CBSql=20
Server =
2000=B5=C4=D7=D4=B6=A8=D2=E5=B7=D6=D2=B3,=B5=AB=CA=C7=D4=DAsql server=20
=
2000=D6=D0,=D2=AA=CA=B5=CF=D6=CF=D4=CA=BE=C4=B3=D2=BB=D2=B3,=BE=CD=B7=B5=BB=
=D8=C4=C7=D2=BB=D2=B3=CA=FD=BE=DD=B5=C4=D0=A7=B9=FB=B5=C4=B7=BD=B7=A8=CA=B5=
=D4=DA=B2=BB=BE=A1=C8=CB=D2=E2.=CD=F8=C9=CF=BA=DC=B6=E0=CD=A8=D3=C3=B5=C4=
=B7=D6=D2=B3=B4=E6=B4=A2=B9=FD=B3=CC,=B5=AB=BF=B4=D7=C5=BE=CD=CD=B7=B4=F3=
.=C8=E7=B9=FB=CA=B9=D3=C3=CE=D2=C7=B0=C3=E6=CC=E1=B5=BD=B5=C4=CA=B9=D3=C3=
in,not=20
=
in,top=C0=B4=BD=F8=D0=D0=B7=B5=BB=D8=CC=D8=B6=A8=D2=B3,=CC=D8=CA=E2=B5=C4=
=CF=DE=D6=C6=D3=D6=BB=E1=B1=C8=BD=CF=B6=E0(=B1=C8=C8=E7ID=D2=AA=B5=DD=D4=F6=
).=CF=D6=D4=DASql Server=20
=
2005=D6=D0=CC=E1=B9=A9=C1=CB=D2=BB=B8=F6=BA=AF=CA=FDROW_NUMBER(),=BF=C9=D2=
=D4=CA=B9=D7=D4=B6=A8=D2=E5=B7=D6=D2=B3=B1=E4=B5=C3=BC=F2=B5=A5=D0=ED=B6=E0=
.<BR> =20
=
=CE=D2=C3=C7=CF=C8=C0=B4=BF=B4=BF=B4ROW_NUMBER()=CA=C7=B8=C9=CA=B2=C3=B4=B5=
=C4.=D6=B4=D0=D0=CF=C2=C3=E6=D5=E2=B6=CESQL=D3=EF=BE=E4:<BR> &=
nbsp; =20
SELECT [ReportID],[UserName], [ReportID],=20
<BR> [TimeStart],=20
[TimeEnd],ROW_NUMBER() OVER (ORDER BY ReportID) AS RowNo=20
<BR> FROM=20
[ExecutionLog]<BR> =20
=
=D6=B4=D0=D0=BD=E1=B9=FB=C8=E7=CF=C2=CD=BC=CB=F9=CA=BE:<BR> &n=
bsp; =20
<DIV forimg=3D"1"><A=20
=
href=3D"http://hiphotos.baidu.com/meilixueshan/pic/item/753763f437f600d3f=
2d38515.jpg"=20
target=3D_blank></A></DIV>
<DIV forimg=3D"1">
<DIV align=3Dcenter forimg=3D"1"><A=20
=
href=3D"http://hiphotos.baidu.com/meilixueshan/pic/item/de4821129135d25bf=
819b81c.jpg"=20
target=3D_blank></A></DIV>
<DIV forimg=3D"1"><IMG class=3Dblogimg=20
=
src=3D"http://hiphotos.baidu.com/meilixueshan/pic/item/de4821129135d25bf8=
19b81c.jpg"=20
border=3D0 =
small=3D"0"></DIV> =20
=BA=DC=BC=F2=B5=A5,ROW_NUMBER() =
=BE=CD=CA=C7=C9=FA=B3=C9=D2=BB=B8=F6=CB=B3=D0=F2=B5=C4=D0=D0=BA=C5,=B6=F8=
=CB=FB=C9=FA=B3=C9=CB=B3=D0=F2=B5=C4=B1=EA=D7=BC,=BE=CD=CA=C7=BA=F3=C3=E6=
=BD=F4=B8=FA=B5=C4OVER(ORDER BY=20
=
ReportID).=CF=D6=D4=DA,=C4=E3=BF=B4=B5=BD=C1=CB=D7=D4=B6=A8=D2=E5=B7=D6=D2=
=B3=B5=C4=D3=B0=D7=D3=C1=CB=C2=F0?:)=CF=C2=C3=E6,=CE=D2=C3=C7=BF=B4=BF=B4=
=D4=F5=C3=B4=BE=DF=CC=E5=D3=A6=D3=C3=D5=E2=B8=F6RowNo=BD=F8=D0=D0=B7=D6=D2=
=B3.<BR><BR> =20
=
=CF=D6=D4=DA,=BC=D9=C9=E8=CE=D2=C3=BF=D2=BB=D2=B3=B5=C4=CA=FD=BE=DD=CA=C7=
10=CC=F5,=CE=D2=C3=C7=BE=CD=BF=C9=D2=D4=CA=B9=D3=C3=C8=E7=CF=C2=CB=F9=CA=BE=
=B5=C4SQL=D3=EF=BE=E4=B7=B5=BB=D8=D6=B8=B6=A8=D2=B3=B5=C4=CA=FD=BE=DD:<BR=
> =20
@"<BR> SELECT TOP =
10 *=20
<BR> =20
FROM<BR> =20
(<BR> SELECT =
top 10=20
[InstanceName], [UserName], [ReportID],=20
<BR> =
[TimeStart],=20
[TimeEnd],ROW_NUMBER() OVER (ORDER BY ReportID) AS RowNo=20
<BR> FROM=20
[ExecutionLog] =
<BR> ) AS=20
A<BR> WHERE RowNo =
> " +=20
pageIndex*10<BR> =20
=
pageIndex=BE=CD=CA=C7=CE=D2=C3=C7=D0=E8=D2=AA=CA=FD=BE=DD=B5=C4=D2=B3=CA=FD=
.=BA=DC=BC=F2=B5=A5,=B2=BB=CA=C7=C2=F0?=B2=A2=C7=D2,=D5=E2=D6=D6=B7=BD=CA=
=BD=BC=B8=BA=F5=C3=BB=D3=D0=CA=B2=C3=B4=CF=DE=D6=C6,=D2=F2=CE=AA=CB=FB=CF=
=E0=B5=B1=D3=DA=B6=D4=D3=DA=C8=CE=BA=CE=BC=EC=CB=F7,=B6=BC=C9=FA=B3=C9=C1=
=CB=D2=BB=B8=F6=D0=C2=B5=C4=C5=C5=D0=F2=C1=D0.=CE=D2=C3=C7=BE=CD=BF=C9=D2=
=D4=CA=B9=D3=C3=B8=C3=C1=D0=BD=F8=D0=D0=D7=D4=B6=A8=D2=E5=B7=D6=D2=B3.=20
<DIV class=3DtmpDiv></DIV>
<DIV class=3DtmpDiv></DIV></DIV>
<P>----2005.11.26 11:43 =
=D0=C7=C6=DA=C1=F9</P></DIV></TD></TR></TBODY></TABLE><BR>
<DIV class=3Dopt><A =
title=3D=B2=E9=BF=B4=B8=C3=B7=D6=C0=E0=D6=D0=CB=F9=D3=D0=CE=C4=D5=C2=20
href=3D"http://hi.baidu.com/meilixueshan/blog/category/asp.net">=C0=E0=B1=
=F0=A3=BAasp.net</A> |=20
<A =
title=3D=BD=AB=B4=CB=CE=C4=D5=C2=CC=ED=BC=D3=B5=BD=B0=D9=B6=C8=CB=D1=B2=D8=
onclick=3D"return addToFavor();"=20
href=3D"http://cang.baidu.com/do/add" =
target=3D_blank>=CC=ED=BC=D3=B5=BD=CB=D1=B2=D8</A> | =E4=AF=C0=C0(<SPAN=20
id=3Dresult></SPAN>) | <A=20
href=3D"http://hi.baidu.com/meilixueshan/blog/item/66e0b1ec044a742462d09f=
f8.html#send">=C6=C0=C2=DB</A> (0)
<SCRIPT language=3Djavascript>=0A=
/*<![CDATA[*/=0A=
var pre =3D =
[true,'FireFox2.0=D6=D0=CA=B9=D3=C387=B6=CB=BF=DA=CE=DE=D0=A7=A3=BF', =
'FireFox2.0=D6=D0=CA=B9=D3=C387=B6=CB=BF=DA=CE=DE=D0=A7=A3=BF','/meilixue=
shan/blog/item/f07bf3f8a9ad450cd8f9fd40.html'];=0A=
var post =3D =
[true,'ruby=BA=CDpython=B5=C4=B1=C8=BD=CF','ruby=BA=CDpython=B5=C4=B1=C8=BD=
=CF', '/meilixueshan/blog/item/1036d13d52f923c49f3d621c.html'];=0A=
if(pre[0] || post[0]){=0A=
document.write('<div =
style=3D"height:5px;line-height:5px;"> </div><div id=3D"in_nav">');=0A=
if(pre[0]){=0A=
document.write('=C9=CF=D2=BB=C6=AA=A3=BA<a href=3D"' + pre[3] + '" =
title=3D"' + pre[1] + '">' + pre[2] + '</a> ');=0A=
}=0A=
if(post[0]){=0A=
document.write('=CF=C2=D2=BB=C6=AA=A3=BA<a href=3D"' + post[3] + '" =
title=3D"' + post[1] + '">' + post[2] + '</a>');=0A=
}=0A=
document.write('</div>');=0A=
}=0A=
/*]]>*/=0A=
</SCRIPT>
</DIV>
<DIV class=3Dline></DIV>
<DIV id=3Din_reader>
<DIV class=3Dtit>=D7=EE=BD=FC=B6=C1=D5=DF=A3=BA</DIV>
<SCRIPT>=0A=
=0A=
var g_spAnnony=3Dtrue;=0A=
=0A=
=0A=
var g_read=3D[=0A=
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -