摘要： create procedure procPage @startIndex int,@endIndex int,@sort varchar(50)='asc'aswith pageTamp as(select row_number() over(order by id @sort) as row,* from dbo.WZ_YouQing)select * from pagetamp where ... 阅读全文