sql server提醒必须声明标量变量
insert into book(ID,书名,价钱,作者)values(1,'语文',23,'小王'),(2,'数学',24,'小红'),(3,'政治',24,'小白'),(4,'英语',24,'小黑');DECLARE @RowsPerPage int, @PageIndex int
SET @RowsPerPage = 2;
SET @PageIndex = 1 ;
select * from
(select * from( select ROW_NUMBER() over(order BY id asc)as r,*from book)as sub
WHERE sub.r BETWEEN (@RowsPerPage * (@PageIndex - 1) + 1) AND (@RowsPerPage * @PageIndex)
这个是做分页的
页:
[1]