MySQL: Select * from tablename Order by rand () Limit 10
SQLSERVER: SELECT TOP 10 * from tablename Order by newid ()