Wednesday, April 27, 2005

Sort randomly

To sort radomly every time you run the query, use this method,
SELECT columnname1, columnname2 FROM YOURTABLE ORDER BY NEWID()

No comments:

Post a Comment