select top 10 
newid() as randomrow, productid, productname 
from Products
order by randomrow
##</code><code>##

select top 1 
Quote, CharacterName, GameTitle, newid() as randomrow  
from dbo.GameQuotes 
order by randomrow