呵呵,终于写了个随机的语句:declare @i as int declare @j as int set @i=10*RAND( (DATEPART(mm, GETDATE()) * 100000 ) + (DATEPART(ss, GETDATE()) * 1000 ) + DATEPART(ms, GETDATE()) )set @j=100*RAND( (DATEPART(mm, GETDATE()) * 100000 ) + (DATEPART(ss, GETDATE()) * 1000 ) + DATEPART(ms, GETDATE()) ) set rowcount @i SELECT * from b where id>@j
原来这么简单! 没看到按钮的回复,我的还是有问题,改改(偷点按钮的语句):declare @i as int set @i=10*RAND( (DATEPART(mm, GETDATE()) * 100000 ) + (DATEPART(ss, GETDATE()) * 1000 ) + DATEPART(ms, GETDATE()) )set rowcount @i SELECT * from b order by newid() set rowcount 0
declare @j as int
set @i=10*RAND( (DATEPART(mm, GETDATE()) * 100000 )
+ (DATEPART(ss, GETDATE()) * 1000 )
+ DATEPART(ms, GETDATE()) )set @j=100*RAND( (DATEPART(mm, GETDATE()) * 100000 )
+ (DATEPART(ss, GETDATE()) * 1000 )
+ DATEPART(ms, GETDATE()) )
set rowcount @i
SELECT * from b
where id>@j
没看到按钮的回复,我的还是有问题,改改(偷点按钮的语句):declare @i as int
set @i=10*RAND( (DATEPART(mm, GETDATE()) * 100000 )
+ (DATEPART(ss, GETDATE()) * 1000 )
+ DATEPART(ms, GETDATE()) )set rowcount @i
SELECT * from b
order by newid()
set rowcount 0