sql server 随机数、随机时间模拟数据插入数据库

ceiling(rand() * 15)  可生成1-15随机数

DATEADD(second,ABS(CHECKSUM(NEWID()))%DATEDIFF(second,'20160501' ,‘20161231’),'20160501') 生成'20160501' -‘20161231’之间随机时间

DECLARE @BDate datetime, @EDate datetime,@id int,@i int

SET @BDate = '20160501'         
SET @EDate = '20161231 23:59:59'   --时间区间
set @i = 1
while @i<100
begin
 set @id = ceiling(rand() * 15) -- 1-15随机数
insert into dt_游览记录表(id,传感器ID,时间) values(@i,@id,convert(varchar(100), DATEADD(second,ABS(CHECKSUM(NEWID()))%DATEDIFF(second,@BDate,@Edate),@BDate),120))
set @i = @i+1
end