--------------------四種方法取表里n到m條紀(jì)錄： -------------------------

1.
select top m * into 臨時表(或表變量) from tablename order by columnname -- 將top m筆插入
set rowcount n
select * from 表變量 order by columnname desc

2.
select top n * from
(select top m * from tablename order by columnname) a
order by columnname desc

3.如果tablename里沒有其他identity列，那么：
select identity(int) id0,* into #temp from tablename

取n到m條的語句為：
select * from #temp where id0 >=n and id0 <= m

如果你在執(zhí)行select identity(int) id0,* into #temp from tablename這條語句的時候報錯,
那是因?yàn)槟愕腄B中間的select into/bulkcopy屬性沒有打開要先執(zhí)行：
exec sp_dboption 你的DB名字,‘select into/bulkcopy‘,true

4.如果表里有identity屬性，那么簡單：
select * from tablename where identitycol between n and

Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=660203