Shulou(Shulou.com)05/31 Report--

This article introduces you how to use row_number () to achieve paging, the content is very detailed, interested friends can refer to, hope to be helpful to you.

The code is as follows:

Create procedure p_News @ pageSize int,@pageIndex int as begin select * from (select *, Row_Number () over (order by Id) as [$Row_Num] from News-- where [$Row_Num] 3 encodes the final result with a consecutive number-- order by must be written in parentheses, because writing after from News will report an error in sql: unless TOP or FOR XML is also specified The ORDER BY clause is not valid in views, inline functions, derived tables, subqueries, and common table expressions.

On how to use row_number () to achieve paging to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.