几年前,当使用不具有此功能的Sql Server 2000时,我们遇到了相同的问题。
我们发现了这种方法,乍一看性能似乎很差,但是却让我们不知所措。
DECLARE @Table TABLE( ID INT PRIMARY KEY)--insert some values, as many as required.DECLARE @I INTSET @I = 0WHILE @I < 100000BEGIN INSERT INTO @Table SELECt @I SET @I = @I + 1ENDDECLARE @Start INT, @Count INTSELECT @Start = 10001, @Count = 50SELECT *FROM ( SELECt TOP (@Count) * FROM ( SELECt TOP (@Start + @Count) * FROM @Table ORDER BY ID ASC ) TopAsc ORDER BY ID DESC ) TopDescORDER BY ID
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)