SQL SERVER里实现随机取记录可这样写:
select top 10 newid() as row, productid, productname
from Products
order by row
参考文章
http://www.builder.com.cn/2006/0724/301184.shtml