自動生成シーケンス番号+開窓関数OVEの使用
select row_number() over (order by name) as rowid, sysobjects.[name] from sysobjects
,
select row_number(XX) over(partition by order by XX [desc/asc]) from table;
partition by ,
order by ,
SQL Server row_number - -
sql over(partition by) - - http://www.cnblogs.com/huangchuxian/p/7808051.html
sql - CSDN https://blog.csdn.net/qweqweqwe159/article/details/70739003