如果是MS SQL Server, 需要从Table1中得到随机的N条记录:create table #table1 (
RANDNO int,
data1 char(10),
data2 char(10) )insert into #table1 (RANDNO , data1, data2) select RAND(), data1, data2 from table1select top N * from #table1 order by RANDNO drop table #table1
我没有试.
RANDNO int,
data1 char(10),
data2 char(10) )insert into #table1 (RANDNO , data1, data2) select RAND(), data1, data2 from table1select top N * from #table1 order by RANDNO drop table #table1
我没有试.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货