表中主键必须为标识列,[ID] int IDENTITY (1,1)
BSD爱好者乐园 N)p7Z w&S/E
J6a3S0u [4s'@[#k7vK11.分页方案一:(利用Not In和SELECT TOP分页)
_b:t*y.Dd/SN4BeY1BSD爱好者乐园"vb7FR^`7JCJ语句形式:
-V9k G,ZF/N1SELECT TOP 页记录数量 *
"D-lk2Zz1FROM 表名
Uq(JO:] J7H[8r1WHERE (ID NOT IN
BSD爱好者乐园-mf8f6Ms (SELECT TOP (每页行数*(页数-1)) ID
-_\5_;H?1 FROM 表名
(?&_sOy*a~~$w1 ORDER BY ID))
BSD爱好者乐园rqXu{[2I$P-k ORDER BY ID
XFhG#JV Qz`1//自己还可以加上一些查询条件
BSD爱好者乐园9V)^ ^ve6@ ?*ka8q%f"M0J.h
QX/ZY1BSD爱好者乐园*}.yOr7j例:
I;S
])BpN.V1select top 2 *
He
G@'D9XYw1from Sys_Material_Type
BSD爱好者乐园Zv2f6sHT0rwhere (MT_ID not in
BSD爱好者乐园S)Z4`s9S9r;p3H (select top (2*(3-1)) MT_ID from Sys_Material_Type order by MT_ID))
7d:A1P-~R2RN
J1order by MT_ID
BSD爱好者乐园-k].V5x+g{(GO&\BSD爱好者乐园6@M(s-B4A-eBSD爱好者乐园{Fp VuL]Uh9O12.分页方案二:(利用ID大于多少和SELECT TOP分页)
k%s$rq`B d9b-A1\Y*\!^$jEbH&E0q.H1语句形式:
BSD爱好者乐园`2Lj)r9rSELECT TOP 每页记录数量 *
?&l;T#m;c2l4T1FROM 表名
BSD爱好者乐园%_KL9{zaO m ]"Y7|WHERE (ID >
+U/LQ&o+Ip,zgHG1 (SELECT MAX(id)
^n \
[^6i/Vt
T1 FROM (SELECT TOP 每页行数*页数 id FROM 表
BSD爱好者乐园
\!b8i,DY1|
EE`L ORDER BY id) AS T)
2r*fr%tD$c:F8j*g1 )
8C
a"I{x1H V1ORDER BY ID
BSD爱好者乐园\?if9A:P