第一次来，请大大们照顾阿

[calfordxj]

一个问题，如何显示特定的行阿，比如前五十行的纪录？

[pengdali]

select top 50 * from 表

[txlicenhe]

select top 50 * from 表 order by 字段

[calfordxj]

如果是第50-100行呢？

[hjb111]

select top 50 * from yourtable

[hjb111]

select identity(int,1,1) as idd,* into #t from yourtable
select * from #t where idd between 50 and 100
drop table #t

[pengdali]

select IDENTITY(int, 1,1) AS ID_Num,* into #temp from 表
select * from #temp where ID_Num between 10 and 20

[pengdali]

select IDENTITY(int, 1,1) AS ID_Num,* into #temp from 表
select * from #temp where ID_Num between 10 and 20

或：

declare @SQLStr varchar(8000)
set @SQLStr='SELECT Top '+cast(@每页大小 as varchar)+' * FROM 表 WHERE 主键列 NOT IN (SELECT TOP '+cast(@每页大小*@第几页 as varchar)+' 主键列 from 表 )'
exec(@SQLStr)