SQL:Row Number to select Statement

SELECT ROW_NUMBER()
        OVER (ORDER BY CustID) AS Row,* from #customers