sqlserver2000分页:DECLARE @PAGETEMP TABLE ( __ROW_NUM INT IDENTITY(1,1), __TID INT ) INSERT INTO @PAGETEMP(__TID) SELECT TOP 30 OrderID FROM dbo.Orders order by RequiredDate SELECT [@PAGETEMP].__ROW_NUM,* FROM Orders,@PAGETEMP WHERE dbo.Orders.OrderID= [@PA