摘要： CREATE PROCEDURE dbo.subjectPager ( @projectid int, @pageSize int, @pageTo int )SELECT * FROM (SELECT TOP (@pageSize*(@pageTo+1)) ROW_NUMBER() OVER(ORDER BY feedbackdate DESC) AS row,* FROM vw_s... 阅读全文