declare @sql varchar(200) set @sql = 'select top '+ cast(ceiling(rand() * 8 + 2) as varchar)+' * from tb' exec(@sql)
--应该是10-12条之间随机查询 declare @sql varchar(200) set @sql = 'select top '+ cast(ceiling(rand() * 2 + 10) as varchar)+' * from tb order by newid()' exec(@sql)
declare @sql varchar(200)
set @sql = 'select top '+ cast(ceiling(rand() * 8 + 2) as varchar)+' * from tb'
exec(@sql)
--应该是10-12条之间随机查询
declare @sql varchar(200)
set @sql = 'select top '+ cast(ceiling(rand() * 2 + 10) as varchar)+' * from tb
order by newid()'
exec(@sql)