SQL SERVER里实现随机取记录可这样写:
select top 10 newid() as row, productid, productname
from Products
order by row
参考文章
http://www.builder.com.cn/2006/0724/301184.shtml
posted on 2012-04-24 17:06 左直拳 阅读(118) 评论(0) 编辑 收藏 举报