SQLserver 生成行号

1、ROW_NUMBER()

SELECT   ROW_NUMBER()  Over (ORDER BY num,line)  as rowId ,* FROM  ORDDTL where NUM = '0000000082'

 

2、按照以下两种写法均可,tabname是你的表名

       

         A： SELECT ( SELECT COUNT(1) FROM tabname WHERE id <= a.id) AS numb, *   FROM tabname a

 

         B： SELECT (SELECT sum(1)  FROM tabname  WHERE id <= a.id) AS 行号, *   FROM tabname a

 

 

      将<= 换成>=号,可以降序

3、还有一种就是 利用identity

Select no=Identity(int,1,1),* Into #temptable From TableName --Order By SortField