摘要:
--sql server 随机读取数据 SELECT TOP 1 * FROM [tablename] ORDER BY NEWID() SELECT * FROM [tablename] where pk in (select top 1 pk from [tablename] ORDER BY NEWID()) --这两个方法都需要排序,因此IO的逻辑读取会比较多,而且CPU占用也多很... 阅读全文
posted @ 2016-11-03 18:10
davidhou
阅读(3644)
评论(0)
推荐(0)
浙公网安备 33010602011771号