//高效的分页查询
SELECT TOP "+ PageSize +" * FORM ( SELECT TOP "+ PageSize * PageId +" ProductName,ProducntCode From Product ORDER BY ID DESC)ORDER BY ID ASC
SELECT TOP "+ PageSize +" * FORM ( SELECT TOP "+ PageSize * PageId +" ProductName,ProducntCode From Product ORDER BY ID DESC)ORDER BY ID ASC