select top 10 
newid() as randomrow, productid, productname 
from Products
order by randomrow