Viewing post 1 (of 1 total)
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
December 4, 2013 at 11:29 pm
Viewing post 1 (of 1 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy