Library code snippets
Randomly Sorting Records
By James Crowley, published on 25 Mar 2005
Ever needed to grab a selection of random rows from a table? Well, it's surprisingly easy in SQL Server 2000, using the NEWID() method. The code below selects 10 random rows from "myTable".
SELECT TOP 10 id,title FROM myTable ORDER BY NEWID()
Great!
James first started this website when learning Visual Basic back in 1999 whilst studying his GCSEs. The site grew steadily over the years while being run as a hobby - to a regular monthly audience ...
Related articles
Related discussion
-
Research topic in software
by reachsangeethamathew (0 replies)
-
Job Opening - New Braunfels, Tx for C# Programmer
by kirkkelly (3 replies)
-
update database when the website is nor running on the browser
by hepsy.i (1 replies)
-
Graphical Reports in C# .net
by gulshanuetian (0 replies)
-
VS.NET/sql server installation problem
by Manjot Bawa (3 replies)
Related podcasts
-
ADO.NET "Astoria" Data Services with Shawn Wildermuth
Scott chats with Shawn Wildermuth, "the ADO Guy," about ADO.NET Data Services, aka "Project Astoria." It's REST for SQL Server. Should you care? What's REST? How does this relate to WCF or ASP.NET?
Events coming up
-
Nov
19
SQLBits V
Newport, United Kingdom
SQLBits is Europe's largest SQL Server conference, and SQLBits V will be the biggest and best yet. On November 19th we are holding a day of pre-conference seminars; on November 20th we have a pay-to-attend day of SQL Server 2008 and R2 content; and on Saturday November 21st we have our usual free community conference.
This thread is for discussions of Randomly Sorting Records.