---分頁(yè)方法
------------1.top分頁(yè)：?
a? where ?a.orderid? not ? in ( select ? top ? 10 ?orderid? from ?Orders? order ? by ?orderid)? order ? by ?a.orderid ?
?
?------------2.MAX函數(shù)
select ? top ? 10 ? * ? from ?Orders?a?
? where ?a.orderid > ( select ? MAX (orderid)? from ?( select ? top ? 10 ?orderid? from ?Orders? order ? by ?orderid)? as ?orderid)?
? order ? by ?orderid ?
?
-------------3.rowcount（）方法
where ?rownumber? between ? 10 ? and ? 20
????
select ? top ? 10 ? * ? from ?( select ?ROW_NUMBER()? over ( order ? by ?orderid)? as ?rownumber, * ? from ?Orders)?myresult?
where ?rownumber > 10
????
with ?OrderedResult? as (
select ? * ,ROW_NUMBER()? over ( Order ? by ?orderid)? as ?rownumber? from ?Orders)
select ? * ? from ?OrderedResult? where ?rownumber? between ? 10 ? and ? 20 ?
?
------------4.建立臨時(shí)表
declare ? @pagelowerbound ? int
declare ? @pageupperbound ? int
set ? @pagelowerbound = 10
set ? @pageupperbound = 20
create ? table ?#pageindex( [ indexid ] ? int ? identity ( 1 , 1 )? not ? null , [ id ] ? varchar ( 18 ))
declare ? @sql ? nvarchar ( 2000 )
set ? @sql = ' insert?into?#pageindex([id])?select?top? ' + CONVERT ( nvarchar , @pageupperbound )
set ? @sql = @sql + ' ?orderid?from?Orders '
execute ?sp_executesql? @sql
select ?a. * ? from ?Orders?a? inner ? join ?#pageindex?b? on ?a.orderid = b.id? where ?b.indexid > @pagelowerbound ? order ? by ?b.indexid
drop ? table ?#pageindex
end ?
?
更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號(hào)聯(lián)系： 360901061
您的支持是博主寫作最大的動(dòng)力，如果您喜歡我的文章，感覺(jué)我的文章對(duì)您有幫助，請(qǐng)用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點(diǎn)擊下面給點(diǎn)支持吧，站長(zhǎng)非常感激您！手機(jī)微信長(zhǎng)按不能支付解決辦法：請(qǐng)將微信支付二維碼保存到相冊(cè)，切換到微信，然后點(diǎn)擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對(duì)您有幫助就好】元
