自动行号

SELECT ROW_NUMBER() OVER (order by USER_ID)as RowNumber,* FROM USERFLM

 

SELECT IDENTITY(int,1,1) as rowId,* FROM test