Never been to DZone Snippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

About this user

Robert Brook http://robertbrook.com

« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS 

Select random row, SQL Server

// select a random row in SQL Server, apparently. Untested.

   1  
   2  SELECT TOP 1 column FROM table
   3  ORDER BY NEWID()
to sql random select SQLServer ms by brook on Feb 26, 2007
« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS