不断的谦逊，不断的努力

set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoCREATE  PROCEDURE [dbo].[GetTreeDetails]    @start int              ,--数据页码    @limit  int              ,--每页显示数据条数    @totalCount int OUT         ,--数据总条数

SQL 分页支持查询 ROW_NUMBER() OVER (ORDER BY ReportID) AS RowNo  分页支持查询 SELECT * FROM (select *,ROW_NUMBER() Over(order by [id]) as row_index from [table] ) as [newtable] where row_index between [star

ROW_NUMBER() 的SQL语句: select * from (     select ID , ArchivesTypeID,SegmentColumnName,SegmentDisplayText,SegmentOrderID,     SegmentSeparator,ROW_NUMBER() over(order by  ID desc ) as RowNum   from MytestTable ) table1 where RowNum  between  1700000 and  17