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 Technology, Project Manager,
Occasional Art Director... man of many hats.
Home » Blog article: Selecting Random Rows in SQL Server 2005
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!
**Disclaimer - The postings on this site are my own and do not necessarily represent the positions, strategies or opinions of George P. Johnson or Juxt Interactive.
Recent Tweets
- @kim Einstein on the Beach http://j.mp/alSaPb in reply to kim 14 hrs ago
- Interesting statistics on which social gaming companies are hiring & which are interested in smartphones: http://j.mp/9g7JgI by @dliman 17 hrs ago
- What to expect on the HTC Droid Incredible running Flash 10.1 > http://j.mp/csQ2Or [video] 17 hrs ago
- More updates...
Browse by Category
- ActionScript (3)
- Adobe Flash (4)
- Alltop (2)
- Analytics (2)
- Application Servers (7)
- Artwork (3)
- Blogs (3)
- C# (2)
- Cloud Computing (2)
- Databases (7)
- Design (8)
- Development (3)
- Diagnostics (1)
- Frameworks (1)
- Gadgets (1)
- Google Webmaster Tools (1)
- Grails (3)
- Groovy (2)
- HTML Development (3)
- Humor (1)
- Industry (5)
- Information Architecture (2)
- Interactive Advertising (3)
- Java (4)
- Juxt Interactive (1)
- Marketing (4)
- Music (5)
- PCI Compliance (1)
- Personal (24)
- Privacy (2)
- Quality Assurance (3)
- Recent Works (4)
- Scalability & Infrastructure (6)
- Search Engine Optimization (1)
- Security (7)
- SEO (1)
- Shepard Fairey (2)
- Sites & Inspiration (4)
- Social Media (1)
- SQL Server 2005 (4)
- Startups (7)
- Troubleshooting (3)
- Twitter (1)
- Uncategorized (3)
- Web Servers (7)
- Work (9)
Archives
- July 2010
- April 2010
- January 2010
- October 2009
- September 2009
- July 2009
- June 2009
- April 2009
- March 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
Recent Comments
Jef wrote:
haha. I had just begun my...
Rob White wrote:
I need to post mine. My...
Chinese translation wrote:
This is great, I was looking...