排序显示行号
select Row_Number() over(order by Code) as RowNumber,ID,Code,Name from CBO_ItemMaster
不排序显示行号
select Row_Number() over(order by (select 0)) as RowNumber,ID,Code,Name from CBO_ItemMaster
SQL Server 零散笔记
原文:http://www.cnblogs.com/jia168/p/7672776.html