摘要: declare @pageindex intdeclare @pagesize intset @pageindex =1set @pagesize =10select * from (select 动态新闻ID,row_number() over(order by 动态新闻ID ) as rowno from dbo.动态新闻) awhere a.rowno <=(@pageindex+1)... 阅读全文