Home Forums Article Discussions Article Discussions by Author Discuss content posted by Press Release SQLServerCentral apologizes and you can win a book RE: SQLServerCentral apologizes and you can win a book
rdward-939670
Grasshopper
Points: 21
More actions
December 4, 2013 at 11:29 pm
#1670921
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