Here is a sample for when you need a row number but don't care what it is ordered by:

SELECT TOP 100 ROW_NUMBER() OVER (ORDER BY (SELECT NULL)), * FROM sys.objects