34,576
社区成员
发帖
与我相关
我的任务
分享
--应该是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)