SQL 2000 How to get a random row from a database


SELECT TOP 10 City, NewID() as Random
FROM dbo.Customers
ORDER BY Random

SQL 2000 code to Get CD KEY Value:

USE master
EXEC xp_regread 'HKEY_LOCAL_MACHINE',
'SOFTWARE\Microsoft\Microsoft SQL Server\80\registration',
'CD_KEY'