Geeks With Blogs
mikedopp Geekswithblogs (edition)

This is a very short post. so bear with me.

 
SELECT *
FROM Northwind..Orders 
ORDER BY NEWID()
The Magic here is NewID()

del.icio.us Tags: ,

LiveJournal Tags: ,
Digg This
Posted on Wednesday, May 20, 2009 7:49 AM | Back to top


Comments on this post: How to get a random record using MSSQL

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © mikedopp | Powered by: GeeksWithBlogs.net