Workaround for SQL Server when using Row_number _mssql

Set SQL Server to use Row_number when not sorted

--1. See NHibernate is so written pagination, it is easier to understand the writing (there should be no efficiency problems?) ）
--with just set an alias?

[SQL]
With query as (select Row_number () 0) as RowNum, * from Product)
SELECT * FROM query where rownum BETWEEN 5 and 10

--2.row_number must be written over (orders by * *), sometimes I do not want to sort at all, want to in the original order (the sort also takes time)

--The method is:
Select Row_number () over (order by (select 0)) as rownum,* from Product

The sort is:
Select Row_number () over (order by oper_date Desc) as rownum,* from Product