Selecting Random Rows in SQL Server 2005
Here is a quick an easy way to select random rows in SQL Server 2005:
SELECT ColumnA, ColumnB FROM dbo.[TableName] ORDER BY NEWID()
Director of Development, Project Manager,
Ocassional Art Director... man of many hats.
Home » Blog article: Selecting Random Rows in SQL Server 2005
Leave a Reply
Thats me above wearing one of my favorite Adidas track jackets. This is my home on the web showcasing some of my work over the past few years in the Interactive Marketing/Advertising field. In addition to my portfolio you'll find some personal information about me as well as some ramblings on some of the research and development I participate in. Enjoy!
Browse by Category
- Application Servers (2)
- Artwork (1)
- Blogs (2)
- C# (2)
- Databases (3)
- Gadgets (1)
- Grails (3)
- Groovy (2)
- HTML Development (2)
- Industry (2)
- Interactive Advertising (1)
- Java (3)
- Music (1)
- Personal (11)
- Privacy (1)
- Quality Assurance (1)
- Scalability & Infrastructure (4)
- Security (1)
- Sites & Inspiration (2)
- SQL Server 2005 (1)
- Startups (5)
- Web Servers (2)
Archives
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
Latest Work
hosted by 
©2007-2008 Brian Jeremy Kupetz. All Rights Reserved. 
February 21st, 2008 at 12:30 am
Thanks for this, I was just wondering “how” exactly it works….
just for clarification, if I were to build a “random image” in ASP.NET this would be what I need to use??