[转] 用ROW_NUMBER()实现取指定行的数据 和从一个表中向另一个表中插入数据并实现某字段每行递增

  以下示例将返回行号为 50 到 60（含）的行，并以 OrderDate 排序。
USE AdventureWorks;
GO
WITH OrderedOrders AS(SELECT SalesOrderID, OrderDate,
ROW_NUMBER() OVER (order by OrderDate)as RowNumber
FROM Sales.SalesOrderHeader )
SELECT * FROM OrderedOrders
WHERE RowNumber between 50 and 60;

从一个表中向另一个表中插入数据并实现某字段每行递增
insert into table_name (colum_list)
select row_number() over(order by colum_name) + start_value,colum_list from table_name2