stored procedure

now browsing by tag

 
Amazon ASP.NET Business BV Commernce database Desktop DirecTv Drupal Flash Green Help Desk Home Server Hosting IIS IM Joomla Keyboard Logo Media Center Messageboard Microsoft Netflix office outlook 2007 PC PS/2 Sharepoint Software SQL SQL Server 2008 stored procedure t-sql Tivo Turbo Lister Typepad USB Visual Studio Web Design Web Development Windows Windows live messenger Windows Vista WordPress XBox 360 Zune
 

Posted by: | on November 4, 2009

SQL Tip: Select a random row from a SQL database table

So how do you select a random row in a SQL database table?

SELECT TOP 1 Name, Address, City
FROM         tbl_Person
ORDER BY NEWID()

This will select a random person every time.

Posted in Blog | No Comments »
Tags: , , , , , ,