Auto Number in SQL on February 26, 2011 ROW_NUMBER() OVER (ORDER BY EMPID ASC) AS ROWID Select auto increment number from select query in SQL Select Statement Auto Number SQL auto number in SELECT Statement +