Selecting Random Rows in SQL Server 2005
Sunday, February 3rd, 2008Here is a quick an easy way to select random rows in SQL Server 2005:
SELECT ColumnA, ColumnB FROM dbo.[TableName] ORDER BY NEWID()
Here is a quick an easy way to select random rows in SQL Server 2005:
SELECT ColumnA, ColumnB FROM dbo.[TableName] ORDER BY NEWID()
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!
Recent Comments
Folake wrote:
Brian, so good to see you...
Greg Huntoon wrote:
Look at you with the big...
Kathy wrote:
Hi, Thanks for the tip. How...