SQL Server Blog
Tim Brown hopefully providing you with useful SQL Server Information
DataSentinel
Thursday, July 06, 2006
SQL 2000 How to get a random row from a database
SELECT TOP 10 City, NewID() as Random
FROM dbo.Customers
ORDER BY Random
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment