sql server提醒必须声明标量变量

huhuhu12138

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)



这个是做分页的